1. Input file-> Transformer -> Peek 2. Keep Tranformer in sequential

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

Question Posted / anil

5 Answers
29619 Views
Genpact, I also Faced
E-Mail Answers

Answer Posted / anil

1. Input file-> Transformer -> Peek
2. Keep Tranformer in sequential mode or Make partition as same
3. Two stage variables
StgPrevSalary
StgCurrSalary

Derivations - StgVariables
StgCurrSalary- StgPrevSalary
Sal- StgCurrSalary

Output
Emp
StgCurrSalary
StgPrevSalary

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2387

Describe stream connector?

1245

On which interface you will be working as a developer?

986

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1171

What is the difference between Datastage 7.5 and 7.0?

1049

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2383

What is ds designer?

1030

What is the difference between server job and parallel jobs?

1092

Enlist various types of routines in datastage.

1185

Explain Quality stage?

1088

How you Implemented SCD Type 1 & Type 2 in your project?

4073

What are constraints and derivations?

1112

Is the value of staging variable stored temporarily or permanently?

930

Difference between server jobs & parallel jobs?

1015

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

2103