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
- 6286 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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is diff b/t sorter t/r and agg have the option sorter property...
How do you take back up of repository?
What is session task and command task?
How do you load only null records into target? Explain through mapping flow.
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
How would you copy the content of one repository to another repository?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the various types of transformation?
what is song in infrmatica...?
How can we update a record in the target table without using update strategy?
Describe data concatenation?
How to improve the performance of a session using sorter transformation?
What is primary and backup node?
