DataStage Questions and Answers

What is the difference between join stage and merge stage?

JOIN : Performs join operations on two or more data sets input to the stage and then outputs the resulting dataset.
MERGE : Combines a sorted master data set with one or more sorted updated data sets. The columns from the records in the master and update data set s arc merged so that the out put record contains all the columns from the master record plus any additional columns from each update record that required.