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
- 29849 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / indu
inputfile-->transformer-->outputfile
create stage variables
current salary
previous salary(intialize this to null)
derive them as below:
current salary-->previous salary
previous salary---> salary
in the output file derive previous salary as below
previoussalary--->current salary
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain how a source file is populated?
Can you define merge?
What is ibm datastage?
How do you start developing a datastage project?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are orabulk and bcp stages?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the different type of jobs in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
what is flow of project?
What is difference between server jobs & parallel jobs?
what is the use of surogate key in datastage
What is the purpose of pivot stage?
What is a quality stage in datastage tool?
What is the difference between passive stage and active stage?
