Editing star schemas

You can edit a star schema according to your needs. Editing options include adding columns, adding attributes and defining filters.

To edit a star schema (fact table):

1. Click the Manage button in the bottom left of the Data Mart panel. The Manage Data Marts window opens.

2. In the left pane, select the data mart containing the star schema you want to edit.

3. Expand the list of start schemas and select the star schema you want to edit. Then either click the Edit button in the lower toolbar or right-click the star schema and select Edit.

   The Edit Star Schema - Name window opens. The following tabs are displayed:

   • General tab: In the General tab, you can edit the star schema name, the fact table name, the fact view name and the description.

     The following option is also available for transactional and aggregated facts:

     • Update fact with changes to Type 2 data warehouse entities - Select this option (the default) if you want the fact table to always be updated with the last record version of any Type 2 data warehouse entities the star schema contains.

       Example:

       Assuming the data warehouse has the following Type 2 entities:

       • Orders
       • Order Details
       • Address

        

       And the data mart consists of the following:

       • Fact = Orders and Order Details
       • Transaction date = Order Date in Orders
       • Dimension = Address (Type 2)

        

       Then the last version of Orders and Order Details will always used and Address will be updated according to the Oder Date.

       See also: Data mart views.

   • Logical Attributes tab: In the Logical Attributes tab, you can add and delete columns, edit a column’s properties, view a column’s lineage, change the column order, and define filters.

     Edit the Logical Attributes tab according to the table below.

   • Physical Table tab: The Physical Table tab provides a preview of the actual "physical" columns that will be created in the database. All editing tasks are performed in the Logical Attributes tab, except for defining table creation modifiers which is performed in the Physical Table tab.

     For an explanation of how to define table creation modifiers, see Defining Fact Table Creation Modifiers.

   • Transaction Date tab: The Transaction Date tab enables you to change the transaction date that you selected when you created the star schema.

     For more information on transaction dates, see the Transaction Date screen.

     Information note

     This tab will not be displayed if your Star Schema Type is "State Oriented".

Editing Logical Attributes