What is diff joiner and lookup

Question Posted / raveendra

4 Answers
7242 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is diff joiner and lookup..

Answer / suresh

lookupT/r is passive tranforamtion where as joiner is active t/r

Is This Answer Correct ?

5 Yes

2 No

What is diff joiner and lookup..

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

What is diff joiner and lookup..

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

What is diff joiner and lookup..

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

Post New Answer