Table of Contents

Search

  1. Version 10.2.1
  2. 10.2
  3. Version 10.1.1
  4. Version 10.1

Window Functions

Window Functions

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
.


Updated July 25, 2019