Interested to Buy Any Domain ? << Click Here >> for more details...
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null?
empid salary previoussalary
10 1000 null
20 2000 1000
30 3000 2000
40 4000 3000
- 5 Answers
- 29807 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / venkata ramana
Input:Seq file
empid,salary
10,1000
20,2000
30,3000
40,4000
Sequential file stage--->Trasformar Stage---->Dataset Stage
Transformation Logic:
InputTab-->Partition--> select "same"---> Select "Perform Sort" on key "empid"
Declaration of Stage Variables:
PrevSal Varchar ( Set right Intial value ' ' i.e Null value)
CurSal Varchar
Derivation Stage Variables
---------- ---------------
CurSal PrevSal
Linkname.Salary CurSal
Derivation Column name
--------- -----------
Linkname.empid empid
Linkname.Salary Salary
PrevSal previoussalary
Output DataSet result:-
empid salary previoussalary
10 1000 null
20 2000 1000
30 3000 2000
40 4000 3000
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What steps should be taken to improve Datastage jobs?
What are routines in datastage?
What are the difference types of stages?
what is the difference between == and eq in UNIX shell scripting?
How do y read Sequential file from job control?
What is meta stage?
To see hidden files in LINIX?
Where do the datastage jobs get stored?
What are some prerequisites for datastage?
Define data aggregation?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is oci?
Distinguish between informatica & datastage. Which one would you choose and why?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
