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
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Define Pmrep command?
Where are the source flat files kept before running the session?
Explain the code page compatibility?
Explain scd type 3 through mapping.
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
What is a standalone command task?
What is a joiner transformation and why it is an active one?
What is repository manager?
What is the use of transformation?
Enlist few areas or real-time situations where informatica is required.
How to load the data from people soft hrm to people soft erm using informatica?
list out all the transformations which use cache?
Explain transaction control transformation in informatica
can anyone suggest best free Talend data integration training online