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
- 6293 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of caches in lookup?
What does command task mean?
How can we use mapping variables in informatica? Where do we use them?
What are the transformations that are not supported in mapplet?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Where is metadata stored?
What do you mean by channel change?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What do you understand by SOA of Informatica?
can u any challenge your project?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Define enterprise data warehousing?
Which are the different editions of informatica powercenter that are available?
Explain the types of transformations?
What are the modules in Power Center
