To deliver fact data to your data warehouse, you need to
create a fact build. You can also use fact builds to deliver dimension
data. A fact build has a data stream, a transformation model, and
a delivery module.
About this task
To create a fact build:
- Start IBM® Rational® Data Manager and load
the extract, transform, and load (ETL) catalog.
- Expand the node, right-click Fact,
and select Insert Fact Build.
- Type a name and click OK.
- Expand the newly created fact build, right-click the Data
Stream node, and click Insert Data Source.
Specify the name of the new data source.
- Click the Query tab. From the database
list, select the required data source.
- Expand the data source node to list the tables under the
operational data store schema and select Request.
- On the Query page, add the SQL code for picking up the
elements from the schema.
- Click the Results tab, select Prepare,
and click Refresh. If prompted, type the date
in the mm/dd/yyyy format. Click OK.
- Right-click the DataStream icon,
click Properties, and click Auto
Map. Click OK.
- Right-click the Transformation Model icon
and select Mapping.
- Click Auto Map and select the property
of the element.
- If the element holds non-additive information that is not
a dimension or a measure, select Create new elements as
an attribute.
- If the element holds a key component of a business for which
you want to analyze data, select Create new elements as
an dimension.
- If the element holds a value of a business dimension, select Create
new elements as an measure.
Click OK.
- Expand the fact build node, right-click Delivery
modules, and select Insert Relational Table
Delivery.
- Type a name.
- On the Table Properties page, complete
these steps:
- Select the data source Connection from
the list.
- Click the Browse button to select the data source Table
name.
- Specify the attributes for the Columns.
- Click Import Target Table, select
the table, and click OK.
- Expand the node, right-click Facts, and
click .
- Type a name and use the Browse button to select the Associated
fact build.
- Click the Predecessors tab, select Start,
and click OK.