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
- 29715 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
Highlight the main features of datastage?
EXPLAIN SCD
How do u convert the columns to rows in datastage?
How rejected rows are managed in datastage?
What is orabulk stage?
What is the differentiate between data file and descriptor file?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
root tree will find which is server job and which is parallel job?
What is the precedence of stage variables,derivations, and constraints?
What are the job parameters?
Define repository tables in datastage?
How can one find bugs in job sequence?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
If you want to use the same piece of code in different jobs, how will you achieve it?
