Warehouse DataStage Interview Question:

Explain What is merge and how it can be done plz explain with simple example taking 2 tables?

Submitted by: Administrator

Merge is used to join two tables.It takes the Key columns sort them in Ascending or descending order.Let us consider two table i.e Emp,Dept.If we want to join these two tables we are having DeptNo as a common Key so we can give that column name as key and sort Deptno in ascending order and can join those two tables
Submitted by: Administrator

The Merge stage combines a master data set with one or more update data sets. The input data should be sorted and key partitioned. The input should not contain duplicate records. Using Merge, we can have the same number of reject links update links.
Submitted by: Akila