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
- 8652 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 override a native sql query within informatica? How do we do it?
How to load last n records of file into target table - informatica
Explain the mapping variable usage example in informatica
What is union transformation?
How to do unit testing in informatica?
Explain constraint based loading in informatica
What is a node in Informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are different types of transformations available in informatica?
Parameter and variable differences
what is the Default Source Option For Update Strategy Transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is xml source qualifier transformation in informatica?
Explain the different dimensions.
