Normalizing an object

A normalizer object is used when you want to pivot on a set of key columns and create new records for a series of columns.

For example, this table has 12 amount columns (for each accounting period). If you want to associate these periods to a data warehouse time dimension you can create fact table records for each of these period columns.

Note: When using the unpivot command for normalizers, any records with null values are excluded. In cases where the source object has null values, this results in fewer number of rows created.