What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Added on Thu, Dec 3, 2009
Snapshot facts are semi-additive, while we maintain aggregated facts we go for semi-additive. EX: Average daily balance A fact table without numeric fact columns is called factless fact table. Ex: Promotion Facts While maintain the promotion...
Read More