Saturday 11 June 2011

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 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)

What is the difference between source qualifier and lookup
Source Qualifier
Lookup
In source qualifier it will push all the matching records.
Where as in lookup we can restrict whether to display first value, last value or any value
In source qualifier there is no concept of cache.
Where as in lookup we concentrate on cache concept.
When both source and lookup are in same database we can use source qualifier.
When the source and lookup table exists in different database then we need to use lookup.

No comments:

Post a Comment