Denormalize an object

  1. On the DWD Designer, select the Designers tab.
  2. Right click on Denormalizers and select New Denormalizer.
  3. In the Denormalizer Wizard, click Select Object.
  4. Locate and select the object in the object tree. Click OK.
  5. Click Next on the Denormalizer Wizard. The wizard displays the columns in the object (available columns) and shows a constant column pane and a value column pane.
  6. Select which columns are to be the denormalize columns:
    Constant Column

    Move the required denormalization constant column into this pane.

    Value Column

    Move the required denormalization value column into this pane. The value column is automatically suggested as prefix. To change the prefix:

    1. Click Set Prefix.

    2. Specify a prefix name.

    3. Click Save.