Unit Price Fact Table

View previous topic View next topic Go down

Unit Price Fact Table

Post  tim_goodsell on Tue Jan 24, 2012 10:40 pm

Hi

I am extracting unit prices for investment options on a daily basis. Is it best to create a fact table for these prices (see below)

Table - Fact_Investment_Option_Unit_Price

Columns:

Investment Option Key
Unit Price Sell Price
Unit Price Buy Price
Effective Date Key

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Unit Price Fact Table

Post  ngalemmo on Tue Jan 24, 2012 10:44 pm

Sure.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Unit Price Fact Table

Post  hang on Wed Jan 25, 2012 12:43 am

Is this a daily snapshot fact for unit price change? If so, it is the simplest solution. However, it should depend on how many investment options would have their price changed each day. If it is low percentage, I would create a transaction dimension with SCD start and end date to track changed Investment Options so that you may have its SK in other fact tables directly instead of having to connect between two fact tables.

If the percentage is high, say more than 50% of investment options will have their price changed each day, and you are only dealing with one transaction fact table and analysing options in the transaction, you may just leave the Unit Price in the transaction fact table.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: Unit Price Fact Table

Post  Sponsored content


Sponsored content


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