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
- 30088 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / indu
input file->transformer-> output file
in transformer declare stage variables as below:
current salaray
salary
previous salary
Initialize previous salary to null
current salary ---> previous salary
previous salary----> salary
In the output file derive the previous salary as
previousalary--->previous slary (stage variable)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the functionalities of link partitioner and link collector?
How many types of hash files are there?
How can we improve the performance in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the differentiate between data file and descriptor file?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the different type of jobs in datastage?
what is ds administrator used for?
How one source columns or rows to be loaded in to two different tables?
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
To see hidden files in LINIX?
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 ?
How a routine is called in datastage job?
What is job control?
Explain entity, attribute and relationship in datastage?
