How to identify usage of Stream Lookup and Merge Join?
The Stream lookup step looks up data on the basis of common field with information coming from other source steps in the workflow. The only matched data coming from the other source steps is added.
Merge Join is used to merge data sets coming from two input streams with a common key column. It can join the two streams on a given key as an Inner Join, Left Outer Join, Right Outer Join or Full Join and outputs a joined set with fields in the two sets.