Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff joiner and lookup
- 4 Answers
- 8774 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
lookupT/r is passive tranforamtion where as joiner is active t/r
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / padmavathi
Joiner:
Can join herterogeneous sources.
Can join non-relational sources.
Can join partially transformed data.
Loopup:
Can reuse cache across session run.
Can reuse cache with mapping.
Can modify cache dynamically
Can query relational table or flat file.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / akhil4
joiner:
1.joiner is active tr.
2. with joiner tr u can not perform noneqi join.
lookup:
1.lookup is a passive tr
2.with joiner tr u can perform noneqi join.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / r.venkata srinivas
The differences between Joiner T/R and Lookup T/R are
mentioned in the following
Joiner Transformation:
1.Joiner is a Active Transformation.
2.It supports left & right outer join
3.Joiner Transformation is not support OR condition
Lookup Transformation:
1.This is a Passive transformation.
2.It does not support Left & Right outer join.
3.Lookup transformation supports Lookup Override.
| Is This Answer Correct ? | 1 Yes | 2 No |
What are session parameters ? How do you set them?
why we are using surogate key in real time give me explanation
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
design of staging area?
what is the need of session partitioning... how it is useful in real time
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
.prm wirh repalce .txt is possible?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
What is the Difference between SetVariable and setmaxvariable in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Teradata 
