How to load the source table into flat file target(with
columns) in informatica?
Answer Posted / ankit kansal
Hi,
Go to session properties and then select target instance from mapping there you will find an option where by default no header is selected just use output field names to provide your mapping column names or you can use command option to manually define your column.
Use echo col1,col2 to provide manual column names while selecting header command option.
http://www.allinterview.com/showanswers/122611.html
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain dynamic target flat file name generation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How do you load alternate records into different tables through mapping flow?
What is the use of code page?
What is olap (on-line analytical processing?
According to his methodology what all you need before you build a datawarehouse
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How you know when to use a static cache and dynamic cache in lookup transformation?
How to generate sequence numbers without using the sequence generator transformation?
How can we delete duplicate rows from flat files?
What is a mapplet/worklet in informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Mention few power centre client applications with their basic purpose?
What is the difference between a repository server and a powerhouse?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?