Learning Informatica PowerCenter 10.x - Second Edition

Configuring Normalizer transformation - ports

Normalizer transformation ports are different from other transformations ports. You cannot edit the ports of Normalizer transformation. To define the ports, you need to configure the Normalizer tab of Normalizer transformation. To add multiple occurring ports in Normalizer transformation, double-click on the Normalizer transformation, and click on Normalizer. Add the columns in the Normalizer tab. You need to add the single and multiple occurring ports in the Normalizer tab.

When you have multiple occurring columns, you need to define those under the occurs option in the Normalizer transformation as shown in the following screenshot:

When you add the columns in the Normalizer tab, the columns ...