|
Answer» Here are some NECESSARY STEPS to set up a Merge in Datastage: - Go to the Stage page Properties Tab
- Now, specify the key column or columns to be merged
- Inside the Stage page Properties Tab, you need to set the Unmatched Masters Mode, Warn on Reject Updates, in addition to setting the Warn on Unmatched Masters options or accept the defaults.
- After that, in the Stage page Link Ordering Tab, you need to check if your INPUT links are correctly IDENTIFIED as "master" and "update(s)," and the output links are defined as "master" and "update reject."
- Most importantly, you need to ensure the required column metadata is specified
- Finally, go to the Output Page Mapping Tab and specify the order of mapping the columns from the input links map to the output columns.
5. What is the difference between the funnel and merge stage in DataStage? | Merge | Funnel |
|---|
| It is a processing stage that can have any number of input links, the same number of reject links, and one output link. | It is a processing stage used for copying multiple input data sets into a SINGLE output data set. | | It is used for combining one master data set with multiple updated data sets. | It is useful in combining multiple datasets into one large data set. |
|
