Question: what is the difference between join and lookup in datastage?
Answer: DataStage: Join vs Lookup vs Merge. 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).