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
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
explan ur project architecture?
How can one identify whether mapping is correct or not without connecting session?
Tell me about MD5 functions in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do we call shell scripts from informatica?
What are the popular informatica products?
What do you understand by term role-playing dimension?
Mention few power centre client applications with their basic purpose?
Why do you use Mapping Parameter and mapping variable?
What is data movement mode in Informatica and difference between them?
How would you copy the content of one repository to another repository?
Is stop and abort are same in informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Briefly define reusable transformation?
