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
- 6353 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
In how many ways we can create ports?
What is the difference between a repository server and a powerhouse?
How does a sorter cache works?
Why union transformation is an active transformation?
What is update strategy transform?
How an expression transformation differs from aggregator transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is xml source qualifier transformation in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
Define the various join types of joiner transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is song in infrmatica...?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is an expression transformation?
