Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3177 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 |
What is an Integration service in Informatica?
If you want to create indexes after the load process which transformation you choose?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
which quality process u can approach in ur project
Hi experts, can anyone tell how much we use plsql in real time
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
in which situations do u go for scds ?
what is the complex transformation you used in informatica
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
What is a repository? And how to add it in an informatica client?
which one is better performance wise joiner or look up
How to recover sessions in concurrent batches?
Teradata 
