Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 10290 Views
- IBM, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / kondeti srinivas
with lookup we can do left join only
but with joiner we can do all the joins(normal,master
outer,detail outer,full outer)
for mutiple matching only it will give one return value
based on lookup policy(first value or last value like that)
in lookup transformation. but in the joiner transformation
it will give the output for all the matchings
if any one knows more than this please let me know
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Describe expression transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Mention a few design and development best practices for informatica?
What is an expression transformation in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
How to improve the performance of a session using sorter transformation?
How to use pmcmd utility command?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the types of transformations?
What is the advantage of informatica?
Did u used latest transformations of 8.6.0? for what?
What is the difference between writing a joiner query in ANSI style and THETA style?
