The Power Center Designer provides a set of transformations in Informatica that perform specific functions.

Example of expression transformation in informatica. For example you have the following expression. Transformation language functions are SQL-like functions that transform data. It also can be used to perform non-aggregate calculations.

The Expression Transformation in Informatica is a passive transformation that is used to perform non-aggregate calculations on the source data. A dynamic port can receive one or more columns from an upstream transformation and create a generated port for each column. A dynamic output port can contain an expression that generates multiple output ports.

You can also enter a text literal enclosed within single quotation marks for example abc. The Decimal datatype has greater precision than Integer so the datatype of the return value is always a Decimal. Informatica transformation can be created using Designer tools such as Mapping Designer Transformation developer and Mapplet Designer then configure the transformation by adding ports properties groups expressions and son on and finally link the transformation to other transformation and target definitions by drag and drop method in the mapping or mapplet.

The following are some of the operations achieved by the expression transformation. You can define input rules to determine which columns a dynamic port receives. Informatica Transformations are repository Objects that are used to perform aggregations sorting merging modifying distributing etc while passing data through them.

A dynamic output port can return one or more generated ports. You can enter one or more characters. This transformation is used when a user wants to perform aggregate functions like sum average etc.

Examples of calculations are concatenating the first and last name adjusting the employee salaries converting strings to date etc. Create a new database target table for example say avg_mks_deptwise. Create a New mapping m_ avg_mks_deptwise.