Informatica provides a transformation language that includes SQL-like functions to transform source data. Use these functions to write expressions and create user-defined functions.

Expressions modify data or test whether data matches conditions. For example, you can use the AVG function to calculate the average salary of all the employees or the SUM function to calculate the total sales for a specific branch. You can create a simple expression that only contains a single function, such as AVG. You can also write complex expressions by nesting functions within functions.

User-defined functions use expression logic to build complex expressions. You can include them in other user-defined functions or in expressions. For more information about user-defined functions, see Components.

© Copyright Informatica LLC 2007, 2021