How do you join more than 3 flat files in informatica?
Answer Posted / 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 |
Post New Answer View All Answers
What is Session and Batches?
what is $$$$?
Define update strategy?
What is an Integration service in Informatica?
Why filter transformation is an active one?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How union transformation is used?
What are the advantages of 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
In informatica workflow manager, how many repositories can be created?
How can a transformation be made reusable?
Describe an informatica powercenter?
What are active and passive transformations?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.