Difference between Joiner Transformation and Lookup Transformation
Joiner | Lookup |
Active Transformation | Passive Transformation |
| 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. |
Support Equi Join Only | Support Equi Join and Non Equi Join |
Joiner used only as source | Lkp used as source and target |
In Joiner on multiple matches it will return all matching records | In Lkp it will return either first record or last record or any value or error value |
posted by Jeyakumar @ Friday, December 02, 2011,
Post a Comment
Note: only a member of this blog may post a comment.