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
- 6269 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
Which development components of informatica have the highest usage?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How many dimensions are there in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you migrate data from one environment to another?
How do you load unique records into one target table and duplicate records into a different target table?
What is session task and command task?
What are the reusable transformations?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
To import the flat file definition into the designer where should the flat file be placed?
How does a rank transform differ from aggregator transform functions max and min?
can u give example for factless fact table
What are roles and groups and benefits of using them?
How to do unit testing in informatica?
What is the commit type if you have a transaction control transformation in the mapping?
