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
- 29615 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
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Is it possible to query a hash file?
How many areas for files does datastage have?
What are system variables and sequencers in datastage
Explain datastage architecture?
Define Routines and their types?
What are the functionalities of link partitioner?
What are some different alternative commands associated with "dsjob"?
Define project in datastage?
Notification Activity
Name the different sorting methods in datastage.
Can you filter data in hashed file?
Differentiate between operational datastage (ods) and data warehouse?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
