How do you join more than 3 flat files in informatica?
- 1 Answers
- 2415 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer / shashikiran
If it is horizontal join then we should use joiner transformation having common columns in both the flat files if it is more than 3 flat files, then number of joiners will no. of flat files - 1 i.e,
if suppose there are 4 flat files then 3 joiners are used.
If the flat files structure is same then we can go for vertical joining by using Union transformation or by using indirect file loading concept.
| Is This Answer Correct ? | 1 Yes | 0 No |
diffrence between command task and control task
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?/
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
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 the facts will be loaded? explain
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
A session S_MAP1 is in Repository A. While running the session error message has displayed
What is mapplet and a reusable transformation?
What is informatica?
What is the command used to run a batch?
Can we get 1st record through Informatica(without sequence number).
Teradata 
