Modelling Problem of Data Marts

View previous topic View next topic Go down

Modelling Problem of Data Marts

Post  abgoosht on Mon Apr 02, 2012 10:36 am

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

abgoosht

Posts : 5
Join date : 2012-01-24

View user profile

Back to top Go down

Re: Modelling Problem of Data Marts

Post  ngalemmo on Mon Apr 02, 2012 2:28 pm

Why isn't price on the order fact? Also, the invoice fact usually carries a reference back to the order and line being invoiced.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum