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

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1041


Define Pmrep command?

851


Where are the source flat files kept before running the session?

858


Explain the code page compatibility?

859


Explain scd type 3 through mapping.

781


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6918


What is a standalone command task?

922


What is a joiner transformation and why it is an active one?

794


What is repository manager?

785


What is the use of transformation?

783


Enlist few areas or real-time situations where informatica is required.

851


How to load the data from people soft hrm to people soft erm using informatica?

793


list out all the transformations which use cache?

905


Explain transaction control transformation in informatica

1058


can anyone suggest best free Talend data integration training online

1498