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

What is the different lookup cache(s)?

621


What are the data movement modes in informatica?

711


What are multi-group transformations?

573


What is Index Caches size?

630


What are the components of the workflow manager?

648






What are the popular informatica products?

656


What is transformation?

670


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4324


Clarify the utilization of aggregator cache record?

584


Explain pushdown optimization and types in informatica

676


Explain the different lookup methods used in informatica?

599


what is index?how it can work in informatica

1597


What are the limitations of joiner transformation?

662


What are the different transaction levels available in transaction control transformation?

685


What is a repository? And how to add it in an informatica client?

677