hai

can you get give me some ideas for constructing a fact table for dataware
housing.And also about the different types of measures in the fact table
like full additive measures,semi-additive measures and fact-less fact table


vidhya

Your fact table should have measures that you would like to report and
analyze. If you wanted to track sales you might have (simplified):

CustomerID
ProductID
StoreID
SalesAmount

Sales Amount is your measure and it can be totaled up so therefore it is
additive.

Semi-Additive measure can be values such as account balances or inventories
(something that is tracked over time). If you have $100 in your account today
and $50 in your account tomorrow, you don't want to state that the total is
$150.

Here is some info on Semi-Additive (it was written under AS 2000 but the
principles still apply)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/semiadd2.asp

Fact-less Facts are basically used to identify the occurance of something
that may not have a measure associated. Essentially the existence of the fact
row counts as 1.

Here is a good Kimball reference for that:
http://www.dbmsmag.com/9609d05.html

-=Steve
[quoted text, click to view]