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)
|
No comments:
Post a Comment
Thank you :
- kareem