Interested to Buy Any Domain ? << Click Here >> for more details...
differnece between joiner and a look up(please don't give
just definitions)....i mean in which scenario it is better
to use joiner and in which scenario better o use lookup ??
- 2 Answers
- 6160 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sukanta
Lookup-
Let suppose you have empno in your source table but the
empno,address,name etc are stored in a lookup table and you
want all detail of employee will be go to target,then look
up is better option.
Lookup is passive transformation and support join on lookup
table basis of src.empno=lkp.empno(+).that means if in the
lookup table not have the source coming empno then it will
return null value for lookup empno.
so let suppose the lookup table is the target table in your
mapping,then you can find out the target table exists the
source record or not.
Joiner
If you want, the join condition satisfied,then the
satisfied all rows should go for next then join condition is
mandatory.Lookup can't do that.
Previous is posted by me.
Regards
Sukanta
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
Why union transformation is an active 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.
How do you promote a non-reusable transformation to reusable transformation?
what is the -ve test case in your project.
What is the difference between informatics 7x and 8x and what is latest version?
Difference between Data and Index Caches?
can anyone explain me about retail domain project in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Informatica Checkpoints
Clarify the aggregator change?
What are the features of complex mapping?
What is an aggregator transformation?
What is the advantage of informatica?
how tokens will generate?
