The transformation language includes a group of window functions that perform calculations on a set of rows that are related to the current row. The functions calculate a single return value for every input row. You can use window functions in mappings that run on the Spark engine.
The transformation language includes the following window functions:
You can use window functions in Expression transformations. If you use a window function in an Expression transformation, the transformation is active.