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)
|
Friday, 21 March 2014
What is the difference between joiner and lookup?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment