Delivering dimension data by using a fact build

When you use a fact build for delivering dimension data, you can create a specific database through a single build.
Before you begin
Prerequisite: You must define dimensions for the fact build.
About this task
To use a fact build to a deliver dimension data:
  1. Start IBM® Rational® Data Manager and load the extract, transform, and load (ETL) catalog.
  2. Expand the Builds and JobStreams > Facts > Fact node, expand the fact build you want to map, expand Delivery Modules and click Dimension Delivery.
  3. Click Insert > Build > Dimension Delivery.
  4. Right-click Dimension Delivery and click Relational Table.
  5. Type a name and click the Output tab.
  6. In the Deliver into database list, select the target database.
  7. In the ID of top parent field, specify the value of the parent attribute of the top-level element in the hierarchy.
  8. Click OK.

Feedback