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:
- Start IBM® Rational® Data Manager and load
the ETL catalog.
- 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 .
- 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.
- Right-click the dimension build and click Insert
Table.
- 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.
- Specify the Commit interval the
interval for the number of rows updated or inserted in the target
table.
- Click the Columns tab. In the Use
template section, select the dimension hierarchy for defining
the behavior of the dimension table.
- In the Available Sources section,
expand the dimension hierarchy node and click Component.
Drag the elements to the Sourced From columns.
Click OK.