Table of Contents

Search

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

What's New and Changed

What's New and Changed

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
.

0 COMMENTS

We’d like to hear from you!