i have two sources two flatfiles same structure
one flatfile contain 100 million recs
another flatfile contain 10 million recs
i have to connect single target(performance oriented answer)
what are the steps we have to do this scenario
Answer Posted / sudheer
As u r using source as flat file so u can go for partitioning preferably Single-Thread or Multi-Thread partitioning.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are some examples of informatica etl programs?
How to create the source and target database connections in server manager?
Is stop and abort are same in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain pmcmd command usage in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the tasks that source qualifier perform?
explain one complex mapping with logic? sales project?
What are the measure objects?
Briefly describe lookup transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Is there any way to read the ms excel datas directly into informatica?
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