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
- 10091 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
explain abt ur project architecture?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to generate sequence numbers using expression transformation?
What are the different transaction levels available in transaction control transformation?
Quickly characterize reusable change?
Make a note of the quantity vaults made in informatica?
What are session parameters ? How do you set them?
How many types of sessions are there in informatica.please explain them?
Did u used latest transformations of 8.6.0? for what?
Is it possible to define a single node as a Gateway node as well as worker node?
What is difference between a gateway node and worker node?
How to do the error handling of if ur source is flatfiles?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is data transformation manager process?
What are the tasks that can be performed using sq?
