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
- 29671 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
What steps should be taken to improve Datastage jobs?
what is ds administrator used for?
What are the different layers in the information server architecture?
What are the components of datastage?
Terminate Activity
what is flow of project?
What is difference between symmetric multiprocessing and massive parallel processing?
Difference between data warehousing and olap?
Differentiate between Join, Merge and Lookup stage?
What are system variables and sequencers in datastage
What are the types of hashed files in data stage
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
which r the connectors used in san?
how to abort the job its matain duplicates?
What is the difference between operational data stage (ods) and data warehouse?
