Need help regarding flat file source in Informatica
Posted on 2009-04-08
Need help regarding informatica flat file source.
I have flat file source with fields,
ID, Name, Address, Date
1, XL, 21-3, Birmingham, 03/02/1999
2, NT, 1-3, Birmingham, 03/02/1999
3, SQ, 13-2, Birmingham, 03/02/1999
I have the target table with same fields or column names(ID, Name, Address, Date).
How to load these records in oracle target ???
In other words how to load address field in target, i can load ID, name, date but not address. Because 'Birmingham' is missing in target address field because " , " is default delimiter.
I am able to load " 21-3 & 1-3 &13-2 " in oracle target but not " birmingham" .
Quick reply would be highly appreciated.