Developing Repository [Physical Layer] : Tennis Tournament

STEP :1

  • Go to file and Select New Repository.1

 

 

  • Create New Repository popup will appear. Provide a Name for the repository, Check the Import Metadata (YES) box.
  • Provide the Repository Password and click on Next.2
  •  Select the Connection Type as OCI 10g/11g from the dropdown menu.
  • Provide the Data Source Name, User Name and Password in the space provided and  select Next.3
  • On the Metadata type, Select Tables and click on Next.4
  •  The Name of the tables will appear on the Data Source View. Select the tables you want to import and drag them to Repository View.

5

  •  Click on Finish.

STEP : 2

  • A screen divided into three parts(i.e: Presentation, Business Model and Mapping & Physical) will appear.
  • Note that the Selected tables should appear on the Physical tab.6
  •  Double click on the Data Source Name and Rename it as TT.7

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Select any physical table so that the screen appears as given by the below screenshot.8

 

 

 

 

 

 

 

 

 

 

 

 

 

  • On the keys tab provide the Key Name and the Column Name of the Primary key. The selected column name will appear as Primary key.9

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Repeat the same for all the tables except the Fact Tables.

STEP : 3

  • Select all the tables you want to link along with a fact table.
  • Right click on the selected tables.
  • Go to Physical Diagram>> Selected object(s) only.

STEP : 4

  • Now all the selected tables along with their column will appear in the tab.
  • Now link the fact table to the dimension table using add joins key as shown below.join
  •  Now click on the W_MATCH_F table and drag the cursor to the W_MATCH_D table.
  • Match the MATCH_WID column of both the tables.11
  •  Now click on the W_MATCH_F table and drag the cursor to the W_COURT_TYPE_D table.
  • Match the COURT_TYPE_WID column of both the tables.11.2
  •  Now click on the W_MATCH_F table and drag the cursor to the W_DATE_D table.
  • Match the DATE_WID from W_DATE_D table and MATCH_DATE_WID from the W_MATCH_F table.11.3
  •  Now click on the W_MATCH_F table and drag the cursor to the W_ROUND_D table.
  • Match the ROUND_WID column of both the tables.11.4
  •  Now click on the W_MATCH_F table and drag the cursor to the W_TOURNAMENT_D table.
  • Match the TOURNAMENT_WID column of both the tables.11.5
  •  Now click on the W_MATCH_F table and drag the cursor to the W_PLAYER_D table.
  • Match the PLAYER_WID column of both the tables.11.6
  •  Now click on the W_MATCH_F table and drag the cursor to the W_STADIUM_D table.
  • Match the STADIUM_WID column of both the tables.11.7
  •  After all the tables have been linked the final star diagram will look as below.12
  •  Now select W_TOURNAMENT_F, W_COURT_TYPE_D, W_PLAYER_D, W_STADIUM_D, W_DATE_D, W_TOURNAMENT_D, W_ROUND_D from the physical layer.
  • Right click on selected table.
  • Go to Physical Diagram>>Selected object(s) only.

STEP : 5

  • Select the Add Join tool on the toolbar.join
  •  Now link all the tables to W_TOURNAMENT_F as done previously with W_MATCH_F.
  • Click on the W_TOURNAMENT_F table and drag the cursor to the W_COURT_TYPE_D table.
  • Match the COURT_TYPE_WID column of both the tables.13.1
  •  Click on the W_TOURNAMENT_F table and drag the cursor to the W_PLAYER_D table.
  • Match the PLAYER_WID column of both the tables.13.2
  •  Click on the W_TOURNAMENT_F table and drag the cursor to the W_STADIUM_D table.
  • Match the STADIUM_WID column of both the tables.13.3

 

  • Click on the W_TOURNAMENT_F table and drag the cursor to the W_DATE_D table.
  • Match the DATE_WID from W_DATE_D and START_DATE_WID from W_TOURNAMENT_F.13.4
  •  Click on the W_TOURNAMENT_F table and drag the cursor to the W_ROUND_D table.
  • Match the ROUND_WID  and START_ROUND_WID column of both the tables.13.5

 

  • Click on the W_TOURNAMENT_F table and drag the cursor to the W_TOURNAMENT_D table.
  • Match the TOURNAMENT_WID column of both the tables.13.6

 

  • The final star structure will look as given below.
    14

 

  • Now save the work. This will show a message to check global consistency. Click on YES.

15

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

16

 

 

 

 

  • Now select any dimension table and Right click on it.
  • Go to New Object>>Alias..
  • Name the alias as Dim_<table_name> and click on ok.
  • Similarly repeat the above steps for all the dimension tables.
  • After creating alias for all the tables the physical layout should look as given below.17.1

 

  • Right click on the USERNAME(E.g: dw_owner) and rename it as per requirement. 18

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • The next step in creation of repository is creating business layer.

To know about creation of business model and mapping, click here.

Leave A Reply

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