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
How might you approve all mappings in the archive all the while?
What all are steps in up gradation of Informatica server?
How to load data in informatica ?
How to extract sap data using informatica?
How can you validate all mappings in the repository simultaneously?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the tuning techniques you applied during your last project
what is informatica metadata?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what is the hint? how to use it to reduce the query processing in program?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we delete duplicate rows from flat files?
What is the benefit of session partitioning?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the different components of powercenter?