how to join two flat files in informatica?
Answers were Sorted based on User's Feedback
If the structure of the two flat files is same we can use SQ.by using in direct
if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this
src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->
Is This Answer Correct ? | 10 Yes | 0 No |
Hi Rajesh
could you plz tell me the steps to join from joiner tr.
Regards
Mehul Thakur
Is This Answer Correct ? | 0 Yes | 1 No |
Write the advantages of partitioning a session?
Explain how many types of dimensions are available in informatica?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
How to update source definition?
How many ways you create ports?
how to move the mappings from your local machine to claint place?
Why should we use star schema in datawarehouse design?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
What is sequence generator transformation in informatica?
performance tuning of Informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How will you check the bottle necks in informatica? From where do you start checking?