Implement OLAP Lead Function in Informatica

[dmishra]

Hi
I want to implement OLAP Lead function in informatica mapping without taking intermediate tables.

Here is the example of requirement.
SOURCE TABLE
ID STATUS FROM_DATE
1 A 20110201
1 B 20110303
1 C 20110306
1 B 20110402
2 A 20110302
2 C 20110304

TARGET TABLE
ID STATUS FROM_DATE TO_DATE
1 A 20110201 20110303
1 B 20110303 20110306
1 C 20110306 20110402
1 B 20110402 SYSDATE
2 A 20110302 20110304
2 C 20110304 SYSDATE

Thanks and Regards

 

[blom0344]

I would post this in the Informatica forum. I remember this was possible in a mapping by defining a variable that worked as a semi-cursor. To long ago to remember the details, but on the INFA forum you should find the answer..

Ties Blom