Answer Posted / raveendra guturi
Union: while we have to join two sources should data
structure same.
)Joiner is active transformation
Lookup is a passive transformation
2)In joiner we can join two heterogeneous sources for
entire Records based on a condition.
But in look up only the first value or last value of the
Records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
3)If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
Solution.
4) Joiner operates on source
Lookup operates on source and target level
5) Joiner does not support non-eqijoin its support equijoin.
Lookup supports non-equijoin
6) Joiner doesnot match for null values
Lookup supports null values
7) join supports only = operator
Lookup supports <=,>=,=,1= operators
9) Joiner supports outer join but lookup doesnot.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what is the size of your data warehousing?
Explain the use of aggregator cache file?
write a query to retrieve the latest records from the table sorted by version(scd)
Design time, run time. If you don't create parameter what will happen
What is the Process to creating lookup transformation in informatica
How can you validate all mappings in the repository simultaneously?
What is the difference between stop and abort in informatica
list out all the transformations which use cache?
What is a standalone command task?
Is there any target staging area in informatica not staging area
What are the modules in Power Center
Performance tuning( what you did in performance tuning)
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Define Pmrep command?
Enlist the tasks for which source qualifier transformation is used.
