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
- 6360 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
Can any body tell about the (UTC) unit test cases with the examples in informatica.
how much memory (size) occupied by a session at runtime
Explain target update override in informatica
in which situations do u go for starflake schema ?
Define enterprise data warehousing?
How the facts will be loaded? explain
is it possible to index the data in cache of lkp transformation ?
WHAT IS FACT TABLES?
What is joiner change?
Why we select the table which has minimum number of records as Master table in joiner?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Teradata 
