We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, February 06, 2014

DataStage Scenario - Design2 - job3

DataStage Scenario Problem -->  DataStage Scenario - Problem2

Solution Design :

a) Job Design :

b) Sort Stage Properties :
In sort stage, we sort the data on Key column (no) and generate the change key column.

c) Filter Stage Properties :
filer the data on "Change" column generated in sort stage.

In filter stage,  condition ( change =1) gives you all values (each once) from input and condition (change=0) gives the all duplicate occurrence from input.

No comments :

Post a Comment