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