· Open custom repository in Offline mode.
· Save it as PCSR_Hierarchies(parent child, skipped and ragged).
· Import GCBC_Sales.Staff_parent_child and Stores_ragged tables into physical layer.
· Create Alias tables.
· Staff_parent_child --> Dim_staff_parent_child.Store_ragged --> Dim_stores_ragged.
· Select Dim_staff_parent_child, Dim_stores_ragged and fact_sales and open the physical diagram.
· In the physical diagram join "Dim_stores_ragged"."store_pk"="fact_sales"."store_id". and "Dim_staff_parent_child"."staff_id"="fact_sales"."staff_id".
Comments
Post a Comment