1)For look-up to work the table need not be present in the mapping.That means you can do a look-up on a table which need not be your source. For a joiner to work the table must exist in the mapping. 2)Look-up can be configured to be unconnected but joiner cannot be unconnected. 3)Look-up does only non-equi join but joiner does outer join.
1 comment:
1)For look-up to work the table need not be present in the mapping.That means you can do a look-up on a table which need not be your source.
For a joiner to work the table must exist in the mapping.
2)Look-up can be configured to be unconnected but joiner cannot be unconnected.
3)Look-up does only non-equi join but joiner does outer join.
Post a Comment