Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.1
  3. Part 2: Versions 10.5 - 10.5.0.1
  4. Part 3: Versions 10.4.1 - 10.4.1.3
  5. Part 4: Versions 10.4 - 10.4.0.2
  6. Part 5: Versions 10.2.2 - 10.2.2 HotFix 1
  7. Part 6: Version 10.2.1
  8. Part 7: Version 10.2 - 10.2 HotFix 2

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
.