Building the Products Dimension Table in the Data Modeler

Building the Products Dimension Table in the Data Modeler

  1. In Data Modeler, click Lock to Edit button.

lock to edit button

  1. The Information dialog box displays confirming that you have successfully locked the model for editing.

information dbox

  1. Click OK. The model is locked by the current user for editing.

locked by current user

  1. In the Database accordion, click the Database Actions icon table actions icon, and select Create view.

Create View

5.   The NEW_VIEW page is displayed.

new view page displayed

  1. Click Add Columns, and select CLOUD_D_COLUMNS from the Database Table/View list.

add columns

7.   In the Columns list, select the following columns:

  • PROD_BRAND
  • PROD_ITEM_DSC
  • PROD_ITEM_KEY
  • PROD_LOB
  • PROD_TYPE
  • PRODUCT

select the following columns

  1. Click Add.

The selected columns are displayed in the new view.

selected columns displayed in the new view

 

  1. Under Properties, in the Name text box, enter V_New_Products, and click Save.

Note: The V_ prefix is used to match the names of database views created automatically as sources for the other dimension tables.

vnew products

  1. Select the SQL Query tab to view the code from the supporting SQL query.

sql query tab

  1. Select the Data tab to view the data.

data tab

  1. Click Add To Model, select Add as Dimension Table, and click OK.

add as dimension table

  1. The V_New_Products dimension table is listed in the Dimension Tables pane.

dimension tables pane

  1. Correct the name of the dimension table toProducts_Newto match the naming convention used for other dimension table names by performing the following steps :
  1. a) Select V_New_Products dimension table.
  2. b) Click the Dimension Table Actions icon table actions icon, and select Inspect.

inspect

  1. The Overview tab for the V_New_Products dimension table is displayed.

overview tab is displayed

16.   Under Properties, in the Name text box, type Products_New, and click Done.

The Products_New dimension table is listed in the Dimension Tables pane.

products new

Leave A Reply

Your email address will not be published. Required fields are marked *