Question: what is the difference between lookup and join in datastage?
Answer: DataStage has three processing stages that can join tables based on the values of key columns: Lookup, Join and Merge. Doing a range lookup. ... Validating a row (If there is no corresponding entry in a lookup table to the key's values, you can output the row in the reject link).