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
- 6355 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
Define Pmrep command?
How to do unit testing in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a mapplet/worklet in informatica?
What is a standalone command task?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain sessions and how many types of sessions are there?
Can we create a Integration service without a Repository service and vice versa?
What are the new features of informatica 9.x at the developer level?
What do you mean by blocking transformation?
In informatica workflow manager, how many repositories can be created?
What is the sequence generator transformation in informatica?
Differentiate between router and filter transformation?
Explain the informatica workflow?
