Preface
Introduction to Informatica Big Data Management
Mappings
Sources
Targets
Transformations
Cluster Workflows
Profiles
Monitoring
Hierarchical Data Processing
Hierarchical Data Processing Configuration
Hierarchical Data Processing with Schema Changes
Intelligent Structure Models
Stateful Computing
Connections
Data Type Reference
Function Reference
- Function Support in a Non-native Environment
- Function and Data Type Processing
  - Rules and Guidelines for Spark Engine Processing

User Guide

Back Next

Rules and Guidelines for Window Functions

Certain guidelines apply when you use window functions on the Spark engine.

Consider the following rules and guidelines when you define window functions in a transformation:

Specify a constant integer as the offset argument in a window function.

Specify a default argument that is the same data type as the input value.

You cannot specify a default argument that contains complex data type or a SYSTIMESTAMP argument.

To use the LEAD and LAG window functions, you must configure partition and order keys in the windowing properties.

To use an aggregate function as a window function in an Expression transformation, you must configure a frame specification in the windowing properties.

Rename Saved Search

Table of Contents

User Guide

User Guide

Rules and Guidelines for Window Functions

Rules and Guidelines for Window Functions