Modelling Problem of Data Marts
2 posters
Page 1 of 1
Modelling Problem of Data Marts
Hi all,
I want to know about how modelling best data marts. For a better understanding the following schema of the data marts:
Fact_table_Order(Order_ID,
Article_ID,
Season_ID,Assortment_ID,
Fact_1
...
Fact_n)
Fact_table_Invoice(Articel_ID,
Invoice_Num,
Invoice_position,
Price
etc.
)
The requirement is to be also able to analyze, for example the fact "price" from the fact table invoice, through a specific season (from the fact_table_Order).
My Question is: How modelling this scenario best? Is is better to add a "Seaon_ID" column to the Fact_table_Invoice and connect the fact table also to the dimension Season or is it better to defer this requirement to the Reporting layer by joining the two fact tables (Data Marts) later and allow to use the season_ID of the fact table Order?
Any advice is welcome.
Thanks and best regards,
Abgoosht
I want to know about how modelling best data marts. For a better understanding the following schema of the data marts:
Fact_table_Order(Order_ID,
Article_ID,
Season_ID,Assortment_ID,
Fact_1
...
Fact_n)
Fact_table_Invoice(Articel_ID,
Invoice_Num,
Invoice_position,
Price
etc.
)
The requirement is to be also able to analyze, for example the fact "price" from the fact table invoice, through a specific season (from the fact_table_Order).
My Question is: How modelling this scenario best? Is is better to add a "Seaon_ID" column to the Fact_table_Invoice and connect the fact table also to the dimension Season or is it better to defer this requirement to the Reporting layer by joining the two fact tables (Data Marts) later and allow to use the season_ID of the fact table Order?
Any advice is welcome.
Thanks and best regards,
Abgoosht
abgoosht- Posts : 5
Join date : 2012-01-24
Re: Modelling Problem of Data Marts
Why isn't price on the order fact? Also, the invoice fact usually carries a reference back to the order and line being invoiced.
Similar topics
» Data Marts Built Upon Data Marts
» Data Marts, Conformed dimensions and Data Warehouse
» Designing data marts from an EAV data source
» Problem with Single Surrogate Keys in the AS-IS/Point in Time Dimensional Modelling
» Dimension Attributes and Fact attributes storing same data in multiple data marts??
» Data Marts, Conformed dimensions and Data Warehouse
» Designing data marts from an EAV data source
» Problem with Single Surrogate Keys in the AS-IS/Point in Time Dimensional Modelling
» Dimension Attributes and Fact attributes storing same data in multiple data marts??
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum