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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,


how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,


SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,


write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,


Explain the different dimensions.

0 Answers  






what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,


What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,


how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,


in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,


Define mapping and session?

0 Answers   Informatica,


how will you get 21 to 30 record from 50 records?

6 Answers  


Categories