DSXchange

GSanthi

i have some employee details with 2000 employees and last 10 years data with 5 departments in a file, how will you find out department wise max and min salary and employee wise max and min salary in same job..explain me stage by stage?

GSanthi

source
id,month,sal
1,jan,1000
1,feb,2000
1,mar,3000
......
......
......
1,dec,12000

Target
id,month,sal,everysal
1,jan,1000,1000,2000,......120000
1,feb,2000,1000,2000,......120000
----------------
-------------
--------------------
1,dec,120000,1000,2000,.....12000

GSanthi

Code: Select all

source             Target
A_B_C              A x
X_Y_Z              B y
                   C Z

I have source like above and get like above target using datastage?

DSXchange

Search found 3 matches

How to get the below scenario using DataStage?

How to design below job in DataStage?

Datastage8.1,