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 / babu
Hi Teja,
The two sources are haveing same structure,so beter to
use list file,to load the data into single TARGET.
Procedure:
----------
1.Place the two source paths in a note pad and
save as it '.list' format.
2.create a maping as per your requirement in
that mapping you have to take only one source no need to
take two sources.
3. Create a session and workflow.
4.In session give a SOURCE FILE PATH
is '.list' file and SOURCE FILE TYPEA as INDIRECT.
Let me know if any thing wrong.
Thanks,
dwarak.vbr@gmail.com
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
Briefly explain the aggregator transformation?
What are the types of caches in lookup?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to extract sap data using informatica? What is abap? What are idocs?
Mention few advantages of router transformation over filter transformation.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a filter transformation and why it is an active one?
How to load the data from a flat file into the target where the source flat file name changes daily?
explain about unit testing? in real time?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain transaction control transformation in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance