Effective in version 10.2, the transformation language introduces window functions. Use window functions to process a small subset of a larger set of data on the Spark engine.
The transformation language includes the following window functions:
- LEAD. Provides access to a row at a given physical offset that comes after the current row.
- LAG. Provides access to a row at a given physical offset that comes before the current row.
For more information, see the "Functions" chapter in the
Informatica 10.2 Transformation Language Reference.