Creating a dimension build

To describe a specific dimension of your business, you need to create dimension builds to deliver dimension data into the data warehouse. A dimension build has a source dimension table, a hierarchy for the data, a target database, and a target table.
About this task
To create a dimension build:
  1. Start IBM® Rational® Data Manager and load the ETL catalog.
  2. Expand the Builds and JobStreams node, right-click Dimensions, and select Insert Dimension Build.
    Note: An alternate task flow is to use the menu bar: Expand the Builds and JobStreams node, click Dimension, and in the menu bar, click Insert > Build > Dimension build.
  3. Type a name and click the Dimension tab.
    • In the Dimension to be delivered list, select the reference dimension.
    • In the Hierarchy/Lookup to be delivered list, select the reference structure for the dimension build to deliver.
    • In the Deliver into database list, select the target database for the dimension build. You can create a new database if you want to.

    Click OK.

  4. Right-click the dimension build and click Insert Table.
  5. Specify the name of the table:
    • If you want to create a new table, type the name.
    • If you want to deliver the dimension data to an existing table, use the Browse button to locate the table.
  6. Specify the Commit interval the interval for the number of rows updated or inserted in the target table.
  7. Click the Columns tab. In the Use template section, select the dimension hierarchy for defining the behavior of the dimension table.
  8. In the Available Sources section, expand the dimension hierarchy node and click Component. Drag the elements to the Sourced From columns. Click OK.

Feedback