Transformation Language
This section describes new transformation language features in 10.2.
Informatica Transformation Language
This section describes Informatica Transformation Language new features in 10.2.
Complex Functions
Effective in version 10.2, the transformation language introduces complex functions for complex data types. Use complex functions to process hierarchical data on the Spark engine.
The transformation language includes the following complex functions:
- •ARRAY
- •CAST
- •COLLECT_LIST
- •CONCAT_ARRAY
- •RESPEC
- •SIZE
- •STRUCT
- •STRUCT_AS
For more information about complex functions, see the "Functions" chapter in the Informatica 10.2 Developer Transformation Language Reference.
Complex Operators
Effective in version 10.2, the transformation language introduces complex operators for complex data types. In mappings that run on the Spark engine, use complex operators to access elements of hierarchical data.
The transformation language includes the following complex operators:
- •Subscript operator [ ]
- •Dot operator .
For more information about complex operators, see the "Operators" chapter in the Informatica 10.2 Developer Transformation Language Reference.
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.