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
- 29874 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
what is the difference between == and eq in UNIX shell scripting?
What is orabulk stage?
How a source file is populated?
What are the main features of datastage?
Describe the main features of datastage?
What is a quality stage in datastage tool?
Why we use surrogate key?
client know skid info?
Explain ibm infosphere information server and highlight its main features?
What are the different common services in datastage?
AGGREGATOR default datatype
Which warehouse using in your datawarehouse
What is the method of removing duplicates, without the remove duplicate stage?
What are transforms and what is the differenece between routines and transforms?
Which algorithm you used for your hashfile?
