Integrating new fact table which has one to many relationship with the main fact table in existing star schema
Page 1 of 1
Integrating new fact table which has one to many relationship with the main fact table in existing star schema
We have a data warehouse with Revenue fact table having Freight Bill Number as the business key (granularity) along with 10+ dimensions. One Freight bill can have one or more commodity line items (commodity description and commodity weight are the main elements). Freight Bill to Commodities is one to many relationship. If the granularity level is same (that is one to one), we could have added the commodity description and weight in the Freight Bill fact table itself. Business users wants to be able to run analysis on commodiy description and calculations on commodity weights.
This Freight Bill Commodity table can be a new fact table with Freight Bill Number and Commodity description as the granularity. All dimensions are common between these two fact tables because they relate to the common key Freight Bill Number. What is the right approach or design (simpler to implement) to implement this one to many relationship between two fact tables. We have OBIEE on top of SQL Server data warehouse.
This Freight Bill Commodity table can be a new fact table with Freight Bill Number and Commodity description as the granularity. All dimensions are common between these two fact tables because they relate to the common key Freight Bill Number. What is the right approach or design (simpler to implement) to implement this one to many relationship between two fact tables. We have OBIEE on top of SQL Server data warehouse.
shankarmetla- Posts : 1
Join date : 2013-08-15
Similar topics
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Star Schema vs All in one table
» Flat Table vs star schema
» Huge table meets star schema
» Fact 1:N Dimension with Star Schema
» Star Schema vs All in one table
» Flat Table vs star schema
» Huge table meets star schema
» Fact 1:N Dimension with Star Schema
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum