Question

Differentiate between joiner and Lookup Transformation.

Answer 1

Below are the differences between lookup and joiner transformation:

• In lookup we can override the query but in joiner we cannot.
• In lookup we can provide different types of operators like – “>,<,>=,<=,!=” but, in joiner only “= “ (equal to )operator is available.
• In lookup we can restrict the number of rows while reading the relational table using lookup override but, in joiner we cannot restrict the number of rows while reading.
• In joiner we can join the tables based on- Normal Join, Master Outer, Detail Outer and Full Outer Join but, in lookup this facility is not available .Lookup behaves like Left Outer Join of database.