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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
During the running session, output files are created by informatica server. Enlist few of them.
How to load the data from people soft hrm to people soft erm using informatica?
How do you load unique records into one target table and duplicate records into a different target table?
Design a mapping to load a target table with the following values from the above source?
How to extract sap data using informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
Briefly define reusable transformation?
What is difference between a gateway node and worker node?
What is dimensional table?
How can we update a record in the target table without using update strategy?
Which means the first record should come as last record and last record should come as first record and load into the target file?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is sorter transformation?
What is the command used to run a batch?