what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9015 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 the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Where can we find the throughput option in informatica?
Is there any target staging area in informatica not staging area
How can one identify whether mapping is correct or not without connecting session?
What is informatica metadata and where is it stored?
How might you approve all mappings in the archive all the while?
How to do the error handling of if ur source is flatfiles?
How to update or delete the rows in a target, which do not have key fields?
What are the tasks that can be performed using sq?
is it possible to index the data in cache of lkp transformation ?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the aggregator transformation?
Enlist the advantages of informatica.
Differentiate between router and filter transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
