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 transformation 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 relational database table. The Normalizer transformation converts columns to rows and also generates an index for each converted row. A sample mapping using the Normalizer transformation 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...