General Datawarehousing Question:
Download Job Interview Questions and Answers PDF
Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Answer:
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.
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.
Download General Datawarehousing Interview Questions And Answers
PDF
Previous Question | Next Question |
What is SCD1 , SCD2 , SCD3? | Explain ssl? |