Informatica Common Components Create an exp component of expression

• In Mapping Designer, select Convert-Create. Select an expression conversion. Enter a name for it (the Convention is Exp_transformationname) and click OK.

• Create an input port.

If you have an input conversion available, you can select the link column from the Layout menu, and then click each port used in the calculation and drag to expression conversion. Using this method, the Designer can copy the port to the new transformation and create a connection between the two ports. Alternatively, you can open the transformation and manually create each port.

Note: If you want this conversion to be reusable, you must manually create each port in the conversion.

• Repeat the previous step for each input port that you want to add to an expression.

• Create the required output port (O) to ensure that the port data type that matches the return value of the expression is assigned. The naming convention for the output port is out_portname.

• Click the small button in the Expression section of the dialog box and enter an expression in the expression editor.

Use the listed port names and functions whenever possible.

If you select a port that is not connected to the conversion, Designer copies the port to the new transformation and creates a connection between the two ports.

Port names that are part of an expression in an expression transformation are more restrictive than those in other conversion types.

• The port name must begin with a single or double-byte letter or a single or double-byte underscore (_).

• Can contain any of the following single or double-byte characters: Letters, numbers, underscores (_), $, #, or @.

• Check the expression syntax by clicking Validate.

　　

If necessary, correct the expression and check the syntax again. Then save the expression and exit the expression editor.

• Connect the output port to the next transformation or destination.

• On the Properties tab, select a trace level to determine the amount of transactions that are reported in the session log file in detail.

• Choose Library-Save.

Informatica Common Components Create an exp component of expression