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 |
I want skip first 5 rows to load in to target? what will be the logic at session level ??
how many types of dimensions are available in informatica?
What r the type of indexes u generally used in informatica?
What is powercenter on grid?
i have two source data there is no pk,fk how to join the two sources
Difference Between ETL & ELT?
Reusable transformation and shortcut differences
Differentiate between joiner and lookup transformation?
What happens if we dont select data driven option?
how can we perform incremental aggregation?explain with example?
Whats the difference between $, $$, $$$
how to obtain performance data for individual transformations.