DataStage Scenario Problem --> DataStage Scenario - Problem9
Solution Design :
a) Job Design :
Below design will achieve the output as per our requirement.
b) Transformer Stage Properties :
Input Source - a Seq file
Ouput target - 3 seq file with data
Map the input column to all 3 outputs.
Now setup constraints (condition) for each Link.
File A - Mod(DSLink2.col1,9)=1 or Mod(DSLink2.col1,9)=2 or Mod(DSLink2.col1,9)=3
File B - Mod(DSLink2.col1,9)=4 or Mod(DSLink2.col1,9)=4 or Mod(DSLink2.col1,9)=6
File C - Mod(DSLink2.col1,9)=7 or Mod(DSLink2.col1,9)=8 or Mod(DSLink2.col1,9)=0
and Now..Compile and Run the job :-)
Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098
No comments :
Post a Comment