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 ??
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?
Write the different tools in the workflow manager?
What are the main issues while working with flat files as source and as targets ?
How to delete duplicate row using informatica?
What is the use of an aggregator cache file?
What is the difference between informatica 7.0 and 8.0?
What is the scenario which compels informatica server to reject files?
When do you use sql override in a lookup transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is the use of target designer?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
In informatics server which files are created during the session rums?
What is flashback table ? Advance thanks
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?