Answer Posted / maruthi
union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is sequence generator transformation in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the uses of etl tools?
Explain about Informatica server process that how it works relates to mapping variables?
What is dimensional table? Explain the different dimensions.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Which transformation is needed while using the Cobol sources as source definitions?
Explain the tuning lookup transformation - informatica
What is session task and command task?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What all are steps in up gradation of Informatica server?
What is status code in informatica?
What is blocking transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
While importing the relational source definition from the database, what are the metadata of source that will be imported?