Database Reference
In-Depth Information
The Normalizer transformation
The Normalizer transformation is used in place of Source Qualifier transformations when
you wish to read the data from the cobol copybook source. Also, a Normalizer transforma-
tion is used to convert column-wise data to row-wise data. This is similar to the transpose
feature of MS Excel. You can use this feature if your source is a cobol copybook file or re-
lational database table. The Normalizer transformation converts columns to rows and also
generates an index for each converted row. A sample mapping using the Normalizer trans-
formation is shown in the following screenshot:
Consider the following example, which contains the salaries of three employees for four
months:
STEVE 1000 2000 3000 4000
JAMES 2000 2500 3000 3500
ANDY 4000 4000 4000 4000
When you pass the data through the Normalizer transformation, it returns the data in a row-
wise form along with the index, as follows:
STEVE 1000 1
STEVE 2000 2
STEVE 3000 3
STEVE 4000 4
JAMES 2000 1
JAMES 2500 2
JAMES 3000 3
JAMES 3500 4
ANDY 4000 1
