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
- 29856 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
which r the connectors used in san?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
On which Dimension Table you implemented SCD Type in your Project
What are datastage sequences?
What is quality stage?
What is ibm datastage?
Define oconv () and iconv () functions in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Is possible to create skid in dim,fact tables?
Can you implement SCD2 using join, transformer and funnel stage?
What is the process of killing a job in datastage?
Explain entity, attribute and relationship in datastage?
How complex jobs are implemented in datstage to improve performance?
What are transforms and what is the differenece between routines and transforms?
Name the different types of Lookups in Datastage?
