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 unit testing?tell me proceedure
How we can create indexes after completing the loan process?
Write the unconnected lookup syntax and how to return more than one column.
What are the differences between joiner transformation and source qualifier transformation?
Explain sessions?
What is InformaticaPowerCenter?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is different between the data warehouse and data mart?
What is native users?
Explain the different lookup methods used in informatica?
What does update strategy mean, and what are the different option of it?
what is the hint? how to use it to reduce the query processing in program?
What are the prerequisite tasks to achieve the session partition?
Explain the mapping variable usage example in informatica
What are the differences between oltp and olap?