Question

Differentiate between Joiner and Lookup transformations.

Answer 1

Joiner	Lookup
It is not possible to override the query	It is possible to override the query
Only the ‘=’ operator is available	All operators are available for use
Users cannot restrict the number of rows while reading relational tables	Users can restrict the number of rows while reading relational tables
It is possible to join tables with Joins	It behaves as Left Outer Join while connecting with the database