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 / aakansha

It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.

Is This Answer Correct ?    15 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of sessions are there in informatica.please explain them?

678


How do you load first and last records into target table?

666


write a query to retrieve the latest records from the table sorted by version(scd)

632


Where is metadata stored?

623


What are the uses of etl tools?

647






which one is better performance wise joiner or look up

628


Why do we need informatica?

554


How to use procedural logic inside infromatica?

636


Where can we find the throughput option in informatica?

600


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

554


what is song in infrmatica...?

1678


As union transformation gives UNION ALL output, how you will get the UNION output?

646


What is update strategy transform?

576


While importing the relational source definition from the database, what are the metadata of source that will be imported?

793


can anyone suggest best free Talend data integration training online

1263