Merge Stage Example

1
40

Merge Stage is a Processing Stage which is used to perform the horizontal combining. This is one of the stage to perform this operation like Join stage and Lookup Stage. Only the difference between the stages are size variance an Input requirements between them.

Example for Merge Stage

Sample Tables

MergeStage_Master

cars,ac,tv,music_system

BMW,avlb,avlb,Adv

Benz,avlb,avlb,Adv

Camray,avlb,avlb,basic

Honda,avlb,avlb,medium

Toyota,avlb,avlb,medium

Mergestage_update1

cars,cooling_glass,CC

BMW,avlb,1050

Benz,avlb,1010

Camray,avlb,900

Honda,avlb,1000

Toyota,avlb,950

MergeStage Update2

cars,model,colour

BMW,2008,black

Benz,2010,red

Camray,2009,grey

Honda,2008,white

Toyota,2010,skyblue

Take Job Design as below

Read and load the Data into all the input files.

In Merge Stage Take cars as Key column. In Output Column Drag and Drop all the columns to the output files.


Give File name to the Target/Output file and If you want you can give reject links (n-1)
Compile and Run the Job to get the required output.
SHARE
Previous articleStages in Datastage
Next articleChange Capture Examples
  • sunitha

    this was a good design, i tried it and understood how a merge stage works