Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

Submitted by: Administrator
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 values of the transaction (ex: product samples) because this table doesn't contain any measures.
Submitted by: Administrator

Read Online General Datawarehousing Job Interview Questions And Answers