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
- 8795 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
Whats there in global repository
What is data movement mode in Informatica and difference between them?
What do you understand by SOA of Informatica?
Explain the different dimensions.
What is meant by a domain?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
can we override a native sql query within informatica? How do we do it?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you mean by blocking transformation?
When do you use sql override in a lookup transformation?
How to load data in informatica ?
What is a repository manager?
What are the differences between a connected lookup and unconnected lookup?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is workflow? What are the components of workflow manager?
