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
Explain the shared cache and re-cache?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create or import flat file definition in to the warehouse designer?
How to extract sap data using informatica? What is abap? What are idocs?
What is a mapplet/worklet in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How you can differentiate between connected lookup and unconnected lookup?
What can we do to improve the performance of informatica aggregator transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the different transaction levels available in transaction control transformation?
Different circumstance which drives informatica server to expel records?
How many input parameters can exist in an unconnected lookup?
What is the session task and command task?
without table how to come first record only in oracle?
what is SDLC way of code development?