My e-Notes about Cloud, K8s, OpenShift, DataScience, Machine Learning, Python, Data Analytics, DataStage, DWH and ETL Concepts


Thursday, 10 September 2015

DataStage Scenario #4 - Insert the 3rd Highest Salary

Scenario :
          Design a job which will read a sequential file having employee data ( name, job, salary, departmenr) and load the 3rd highest salary in a department to the target.

Example Input :

 name  salary  department
Atul 45000 ETL
Neeraj 40000 ETL
Swapna 62012 Oracle
Divya 84699 Reporting
Raj 17386 SAP
Venki 30073 Reporting
Partha 52760 ETL
Akhil 75447 SAP
Nitin 29834 Reporting
Kumar 84221 Oracle
Amish 38608 SAP
Kawshik 51023 Reporting
Surya 63438 ETL
Murali 75853 Reporting
Rajesh 88268 SAP

Output Expected

 name  salary  department
Partha 52760 ETL
Kawshik 51023 Reporting
Akhil 75447 SAP

For more Scenario -  CLICK HERE

Like the below page to get update!forum/datagenx
Follow my blog with Bloglovin

No comments:

Post a Comment


The postings on this site are my own and don't necessarily represent IBM's or other companies positions, strategies or opinions. All content provided on this blog is for informational purposes and knowledge sharing only.
The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of his information.