i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/
Answer Posted / arnab
Concat all the files using a Unix shell script to create a
new file and use this as the source file
If you use windows create a dos batch script
Then call the Unix shell script before calling the session
in the workflow , so that the process is automated
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can one identify whether mapping is correct or not without connecting session?
What is the function of aggregator transformation?
what is size of u r database?
What are Dimensional table?
Enlist few areas or real-time situations where informatica is required.
State the limitations where we cannot use joiner in the mapping pipeline?
What are the main issues while working with flat files as source and as targets ?
What is a difference between complete, stop and abort?
How to do unit testing in informatica?
What is the meaning of decode in informatica?
lookup transformation with screenshots
Clarify the aggregator change?
Define sessions in informatica etl?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain the pipeline partition with real time example?