Normalizer transformation

Normalizer transformation is used in place of Source Qualifier transformation when you wish to read the data from the Cobol Copybook source. Also, 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 tables. Normalizer transformation converts columns to rows and also generates an index for each converted row. A sample mapping using Normalizer transformation is shown in the following screenshot:

Consider the following example that contains 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 Normalizer transformation, it returns the data in a row-wise form along with the index as shown here:

STEVE 1000 1STEVE 2000 2STEVE 3000 3STEVE 4000 4JAMES 2000 1JAMES 2500 2JAMES 3000 3JAMES 3500 4ANDY 4000 1ANDY...