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
- 30093 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / indu
input file-->transformer--> output file
declare stage varibales
current salary
previous salary and initialize the previous salary to null
current salary--> previous salary
previous salary->salary
in the output file derive previousalary as
previoussalary-->current salary (stage variable)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
What are iconv and oconv?
What are routines in datastage? Enlist various types of routines.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
in oracle target stage when we use load option and when we use upsert option?
What are the types of hashed files in data stage
what is repositery?
What is the difference between in process and inter process?
How can we improve the performance in datastage?
Define data aggregation?
How to reverse the string using unix?
how to sort two columns in single job in datastage.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Lookup constraints
