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
How many types of sessions are there in informatica.please explain them?
How do you load first and last records into target table?
write a query to retrieve the latest records from the table sorted by version(scd)
Where is metadata stored?
What are the uses of etl tools?
which one is better performance wise joiner or look up
Why do we need informatica?
How to use procedural logic inside infromatica?
Where can we find the throughput option in informatica?
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?
what is song in infrmatica...?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is update strategy transform?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
can anyone suggest best free Talend data integration training online