What is diff joiner and lookup
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 |
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Why do we need informatica?
what is left outer join?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
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
What do you mean by filter transformation?
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?
why normalizer transformation can not used in mapplet? plzzzz answer
what is informatica metadata?
How to handle decimal places while importing a flatfile into informatica?
what is data modelling? what are types of modelling?In which suituation will use each one?
What is the use of transformation?