Thursday, February 25, 2016

Normalizer Transformation In Informatica

Normalizer Transformation

- The Normalizer transformation can be used in two
differene ways in Informatica mappings:

1.
Pipeline Normalizer Transformation: A transformation
that processes multiple-occurring data from relational tables or flat files is
called as Pipeline Normalizer.

Øreturns
a row for each instance of the multiple-occurring data.

ØRelational
and flat file sources can be connected as input to Pipeline Normalizer

ØThe
Pipeline Normalizer transformation receives a row that contains
multiple-occurring columns and Threre will be two control elements called level
and occurs

ØThe
occurs clause defines the number of occuring elements for each key object

ØThe
Level property of Normalizer allows you to group the data at different Levels

ØThe
Occurs property of Normalizer allows you to specify number of occuring
instances of a source

2.
VSAM Normalizer Transformation : The Normalizer transformation can be aslo used
as a source qualifier transformation to read data from COBOL sources. This transformation
which can be connected to COBOL sources to read data is called VSAM Normalizer
Transformation

Below is an example of General Configuration of a
Normalizer transformation for Quarterly Sales data.