Table of Contents

Search

  1. Preface
  2. Understanding Mapping Architect for Visio
  3. Mapping Templates
  4. Mapping Objects
  5. Mapping Template Rules
  6. Using the Import Mapping Template Wizard
  7. Using the mapgen Command Line Program
  8. Using Informatica Mapping Templates
  9. Appendix A: Glossary

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Pipeline Normalizer Transformation

Pipeline Normalizer Transformation

The pipeline Normalizer transformation receives a row that contains multiple-occurring columns and returns a row for each instance of the multiple-occurring data. The transformation processes multiple-occurring columns or multiple-occurring groups of columns in each source row.
For example, you might have a relational table that stores four quarters of sales by store. You need to create a row for each sales occurrence. You can configure a pipeline Normalizer transformation to return a separate row for each quarter.
Use the pipeline Normalizer transformation to process multiple-occurring data from relational tables or flat files. You cannot use a VSAM Normalizer in Mapping Architect for Visio.
The following table describes the required properties for the pipeline Normalizer transformation:
Transformation Property
Description
Transformation Name
Name of the transformation.
Column Name
Name of the source column.
Level
Group columns. Columns in the same group occur beneath a column with a lower level number. When each column is the same level, the transformation contains no column groups.
Occurs
The number of instances of a column or group of columns in the source row.
Datatype
The transformation column datatype. Can be String, Nstring, or Number.
Prec
Precision. Length of the column.
Scale
Number of decimal positions for a numeric column.
Key Type
Key type for the column. Can be Primary, Alternate, Primary Duplicate, Alternate Duplicate, or Not a Key.
You must set the All Ports rule to link ports in the previous transformation or source qualifier to ports in a pipeline Normalizer transformation. Depending on the number of occurrences for a field, Mapping Architect for Visio can generate additional ports.

0 COMMENTS

We’d like to hear from you!