Mapping Architect for Visio Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Steps to Create a Pipeline Normalizer Transformation

To create a pipeline Normalizer transformation:

Drag the pipeline Normalizer transformation shape from the Informatica Stencil to the drawing window.

Link the pipeline Normalizer transformation to the previous transformation or source qualifier in the mapping and set the All Ports rule.

In the Configuration tab, click New Column to add a new column.

By default, all new records are at column-level number 1, which is the Root level.

From the list of parent records, select the parent record in which to add a new column.

Enter the name, datatype, precision, scale, and keytype.

To create a multiple-occurring column, enter the number of occurrences in the Occurs column.

To create a group of multiple-occurring columns, select the column and click Level.

Mapping Architect for Visio adds a NEWRECORD group level column above the selected column. NEWRECORD becomes Level 1. The selected column becomes Level 2. You can rename the NEWRECORD column.

You can change the column level for other columns to add them to the same group.

To make a column the same level as the column above it, select the column and click Level.

Change the occurrence at the group level to make the group of columns multiple-occurring.

Click Apply to save the columns and create input and output ports.

Mapping Architect for Visio creates the Normalizer transformation input and output ports. It also creates the generated key columns and a column ID for each multiple-occurring column or group of columns.

In the Properties tab, you can change the tracing level, set the Reusable or Is Shortcut properties, or reset the generated key sequence numbers after the next session.

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Steps to Create a Pipeline Normalizer Transformation

Steps to Create a Pipeline Normalizer Transformation