Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
- 1 Answers
- 1402 Views
- Informatica, I also Faced
- E-Mail Answers
Answer / Mitul Saxena
To achieve this, you can use a Session variable to store the previous row's salary and a Script Transformation to update the session variable during each iteration. In the script, access the current row's salary and assign it to the session variable if there is a pervious row. If not, set the session variable to null. Then, in the next transformation, use the session variable to get the previous row's salary.
| Is This Answer Correct ? | 0 Yes | 0 No |
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
how do u move the code from development to production?
What is Micro Strategy? Why is it used for?
How can we integrate different flat file data in a single mapping and with in a single execution
What are the databases that informatica can connect to windows?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Can informatica load heterogeneous targets from heterogeneous sources?
What are set operators in Oracle
how to duplicates from expression transformation without using sorter before that
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What is a candidate key?
Teradata 
