what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9041 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
Describe data concatenation?
What is an expression transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
can we override a native sql query within informatica? Where do we do it?
How identifying bottlenecks in various components of informatica and resolving them?
How to partition the Session?
What are the different types of repositories created using informatica?
How to do unit testing in informatica?
What are the popular informatica products?
What is the commit type if you have a transaction control transformation in the mapping?
design of staging area?
What is domain and gateway node?
What is a filter transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
