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


Please Help Members By Posting Answers For Below Questions

Enterprise data warehouse your projects phase by phase explain?

1466


Differentiate between reusable transformation and mapplet.

574


how many types of dimensions are available in informatica?

563


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1501


What are the components of workflow manager?

588






list out all the transformations which use cache?

691


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10280


What is a predefined event?

662


Please let me know how to make Data masking in informatica..

1269


What is domain in terms of informatica?

563


What is the difference between Active and Passive transformation?

633


what is song in infrmatica...?

1678


What is meant by pre and post session shell command?

626


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

632


have u done any performance tuning? how u ll do?

1859