Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to elaborate tracing level?
Write the prerequisite tasks to achieve the session partition?
How can we use mapping variables in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is lookup change?
How to join three sources using joiner?
Did u used latest transformations of 8.6.0? for what?
What is a surrogate key?
What is parallel processing in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the function of look up transformation?
Explain Dataware house architecture .how data flow from intial to end?
How can we use batches?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
