How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
Answer Posted / chandrababu naidu
by using a concept called filemerging
we will give the path of all files in a sinle file
and in session properties select file type is indirect
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What's the layout of parameter file (what does a parameter file contain?)?
What is decode in static cache?
Describe expression transformation?
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
How to create Target definition for flat files?
What is the need of an ETL tool?
How do you load alternate records into different tables through mapping flow?
COM components can be used in Informatica
What is DR strategy for Informatica project?
How many number of sessions can one group in batches?
hi real timers . iam waiting for ur reply regarding ETL TESTING
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is joiner transformation?
How many types of sessions are there in informatica.please explain them?
Differences between version 7.x and 8.x.