Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Unit Price Fact Table

3 posters

Go down

Unit Price Fact Table Empty Unit Price Fact Table

Post  tim_goodsell 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

Back to top Go down

Unit Price Fact Table Empty Re: Unit Price Fact Table

Post  ngalemmo Tue Jan 24, 2012 10:44 pm

Sure.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Unit Price Fact Table Empty Re: Unit Price Fact Table

Post  hang 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

Back to top Go down

Unit Price Fact Table Empty Re: Unit Price Fact Table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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