Question: what is the difference between join merge and lookup in datastage?
Answer: The Merge stage can have any number of input links, single output links and the same number of reject output links as the update input links. A master record and an update record are merged only if both of them have the same values for the specified merged key. In another word, merge stage does not do range lookup.