What is the difference between joiner and lookup?

                                                                                                                                                                      

Scenario:

What is the difference between joiner and lookup?

Solution:

Joiner	Lookup
In joiner on multiple matches it will return all matching records.	In lookup it will return either first record or last record or any value or error value.
In joiner we cannot configure to use persistence cache, shared cache, uncached and dynamic cache	Where as in lookup we can configure to use persistence cache, shared cache, uncached and dynamic cache.
We cannot override the query in joiner	We can override the query in lookup to fetch the data from multiple tables.
We can perform outer join in joiner transformation.	We cannot perform outer join in lookup transformation.
We cannot use relational operators in joiner transformation.(i.e. <,>,<= and so on)	Where as in lookup we can use the relation operators. (i.e. <,>,<= and so on)