Friday, 21 March 2014

What is the difference between joiner and lookup?

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’t perform any filters along with join condition in joiner transformation.
We can apply filters along with  lkp conditions using lkp query override 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)

No comments:

Post a Comment