what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9327 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 are roles and groups and benefits of using them?
How can we handle two sessions in informatica?
What are the types of presistent cache in look up tr.
How are indexes created after completing the load process?
How many numbers of sessions can one group in batches?
Under which circumstances, informatica server creates reject files?
What is workflow? What are the components of the workflow manager?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is informatica? Why do we need it?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How many ways a relational source definition can be updated and what are they?
what is Active lock explain
design of staging area?
difference between repository database and repository service?
What is native users?
