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
- 10270 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
Can we change Dynamic to Static or Persistent cache? If so what happens?
Describe data concatenation?
without table how to come first record only in oracle?
Why is sorter an active transformation?
What is depict expression change?
What is mapping debugger?
what is INFORMATICA TESTING process
Is stop and abort are same in informatica?
How to create or import flat file definition in to the warehouse designer?
What is a joiner transformation?
Target increases every day even though no new record was inserted
What is domain and gateway node?
Explain in detail scd type 2 through mapping.
How we can create indexes after completing the load process?
Suppose we do not group by on any ports of the aggregator what will be the output?
