Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8554 Views
- Polaris, I also Faced
- E-Mail Answers
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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Mention a few design and development best practices for informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Make a note of the quantity vaults made in informatica?
how many types of dimensions are available in informatica?
What is joiner transformation?
Have you worked with/created Parameter file
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is meant by query override?
What are the tasks that can be performed using sq?
Can we create a node as a gateway node and the same node can be assigned to a grid?
permutations of mapplet
Explain the aggregator transformation?
How to extract sap data using informatica?
