Creating a fact build

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:
  1. Start IBM® Rational® Data Manager and load the extract, transform, and load (ETL) catalog.
  2. Expand the Builds and JobStreams > Facts node, right-click Fact, and select Insert Fact Build.
  3. Type a name and click OK.
  4. 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.
  5. Click the Query tab. From the database list, select the required data source.
  6. Expand the data source node to list the tables under the operational data store schema and select Request.
  7. On the Query page, add the SQL code for picking up the elements from the schema.
  8. Click the Results tab, select Prepare, and click Refresh. If prompted, type the date in the mm/dd/yyyy format. Click OK.
  9. Right-click the DataStream icon, click Properties, and click Auto Map. Click OK.
  10. Right-click the Transformation Model icon and select Mapping.
  11. 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.

  12. Expand the fact build node, right-click Delivery modules, and select Insert Relational Table Delivery.
  13. Type a name.
  14. 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.
  15. Click Import Target Table, select the table, and click OK.
  16. Expand the Builds and JobStreams > Jobs > StarJobs node, right-click Facts, and click Insert Node > Fact Build Node.
  17. Type a name and use the Browse button to select the Associated fact build.
  18. Click the Predecessors tab, select Start, and click OK.

Feedback