WhereScape RED provides functionality for importing data models from modeling tools.
The process to import a model is:

  1. Create the physical data model in the modeling tool.
  2. Generate DDL for the physical model in the modeling tool.
  3. Run the DDL in the data warehouse database to create empty versions of the model tables.
  4. Retrofit the tables in the dummy database into the WhereScape RED metadata as Retro objects.
  5. Convert the Retro objects to Dimensions and Facts.

The following instructions outline steps 4 and 5 above:

  1. Right-click the Retro object group in the object tree in the left pane and select Select Source Tables.

  2. The Retrofit tables dialog is displayed. In the Source Connection drop-down list choose the DataWarehouse connection. A list of databases appears in the left pane (your list will be different).

  3. Double-click the data warehouse database/schema in the left pane list. A list of tables in the database is displayed in the middle pane.

  4. Click the required tables in the middle pane list and click > to move them to the right pane. Then click the Add Ancillary Columns (e.g. dss_update_time) check box. Click OK.
  5. Double-click the Retro object group in the object tree in the left pane. Select all objects in the middle pane, right-click, and select Convert to Target Object.

    If the appropriate Target Object Type has not been set for one or more Retro objects; in the right-click menu select Change Target Object Type and select the correct Object Type.


  6. The new aggregate tables are imported and listed in the Aggregate object group in the left pane.



  7. At this stage, you have only created the table metadata. To create the tables in the data warehouse, double-click the object group in the left pane. In the middle pane highlight the tables, then right-click and select Create (ReCreate).


 

  • No labels