Normalizer Transformation in Informatica

Normalizer Transformation

• Active and Connected Transformation
• Normalizer transformation convert  rows that having multiple occurring columns to a single row for each instance of multiple occurring data.

Scenario

We want to convert quarter sales in a shop to a single sales column.

Source 

Expected Output

Mapping using Normalizer Transformation.

Step 1:

Import Source and target to Source analyzer and Target Designer under Designer tab.

Step 2:

• Drag source and target to mapping designer and import normalizer transformation into the mapping.
• We can't drag ports directly form source qualifier to normalizer. to add ports we can use Normalizer tab.

• Add the output ports you need as output for this transformation.
• As we want to convert 4 Quarter sales to a single sales column output give Occurs of SALES to 4
• This will create 4 input ports and we can map this Quarter sales to this ports

• In transformation tab you can change the name of the transformation.

• Properties tab you can see two options Reset and Restart
• Reset option is used to reset the key value to the value that is used before the session.
• Restart option is used to start the generated sequence from 1 and restart for each session.
• Tracing level represents the amount of information that informatcia server writes in a log file.

Step 3:

• After creating ports and mapping input ports to the transformation you can map the transformation ports to the target
• You can see two additional ports are created in transformation 




• GK: Generated Key - The integration service increments the generated key sequence number each time it process a source row. When the source row contains a multiple-occurring column or a multiple-occurring group of columns, the normalizer transformation returns a row for each occurrence.



• GCID: Generated Column ID - The GCID is an index for the instance of the multiple-occurring data. For example, if a column occurs 3 times in a source record, the normalizer returns a value of 1,2 or 3 in the generated column ID.
• Map GCID colum to Quarter in target table

Step 4:

• Now save your mapping and generate a workflow and run your workflow

Step 5:

• You can check the status of your workflow in Workflow Monitor 

Thank you.