Logic needed

[HemaV]

Input:
employee_id, salary
-------------------
10, 1000
20, 2000
30, 3000
40, 5000

output:
employee_id, salary, next_row_salary
------------------------------------
10, 1000, 2000
20, 2000, 3000
30, 3000, 5000
40, 5000, Null

I need a Datastage job to get this output.

[zulfi123786]

interview question ?

[SURA]

couple of years before, this logic was asked in an interview to me!!

Fine you can sort the data in desc and use stage variable in the TFM

[ray.wurlod]

Good luck getting the null in the final row!

[HemaV]

Fine you can sort the data in desc and use stage variable in the TFM

can you please give tell me how to use the stage variable in the transformer

[priyadarshikunal]

You really need to read the documentation of transformer and stage variables first.

[chulett]

So you haven't used stage variables yet? Do you have any experience with other ETL tools? They are variables that are local to the transformer and are (for all practical purposes) identical to variable ports in Informatica, if that helps at all.

If it doesn't, is there anyone you work with who could give you a quick tutorial? Otherwise, as noted, they are discussed in the Defining Local Stage Variables section of the Parallel Job Developer's Guide (parjdev.pdf in your version).