DataStage Scenario Problem --> DataStage Scenario - Problem10
Solution Design :
a) Job Design :
Below is the design which can achieve the output as we needed. In this design, we are reading the data from flat file, generating a dummy column in column generator stage, doing aggregate on that and sending the output to seq file.
b) Column Generator Stage :
In column generator stage, we will generate a column DUMMY having value 'X' for all the rows which we are reading from the seq file
For generating value 'X' for all the rows, need to change extended metadata for the column DUMMY. Set generator for Cycle algorithm with value 'X'
Map the Salary and DUMMY column to output of Column Generator stage
c) Aggregator Stage :
In aggregator stage, we will aggregate on the DUMMY column and calculate the MAX of Salary.
and Map the Max Salary to Output .
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUvzA0_6GTeP5m8LTius0gJsNhDRAJMdGC6LRl1pycuL8Xn6Nmyp_Zcs6tpBAZ2O9cz9ttUXosV3NLhhpfQUI9jtLGI5U1OrX1f5F4pWZKGW3_ApvgvUPDkiTQXu42Wtnyabw0ZGn_3sY/s1600/DSP10_jb1_agg_colmap.jpg)
For More --> HIT this LINK
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