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 persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the transformations that are not supported in mapplet?
Mention a few design and development best practices for informatica?
Which are the different editions of informatica powercenter that are available?
How do you set a varible in incremental aggregation
explan ur project architecture?
What is xml source qualifier transformation in informatica?
Explain the shared cache and re-cache?
What is the sql query overwrite in source qualifier in informatica
scenario where i can use only concurrent execution of workflow.
What is the surrogate key?
What is data movement mode in Informatica and difference between them?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is Cognos script editor?
Differences between connected and unconnected lookup?