How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / mallikarjun
Hi Ajith,
It is Possible to Join data from a flat file and a relation
source, this can be done with the help of a joiner
transformation where you have to map one input port to the
relation data column and other to the flat file coumn and
give the joiner condition.. Hope this will help you or drop
a mail...
Thanks & Regards,
Mallikarjun
Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What is mapping debugger?
What does “tail –f” command do and what is its use as an Informatica admin.
Did u used latest transformations of 8.6.0? for what?
What is event and what are the tasks related to it?
What is meant by incremental aggregation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to start a workflow using pmcmd command?
What are the different ways to implement parallel processing in informatica?
What is a node in Informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
difference between repository database and repository service?
How big was your fact table
Explian the Process of deployment groups 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