Multiple choice technology enterprise content management

Two facts based on same dimensions can be stored in the same fact table. Is this right?

  1. Yes, as long as the granularity is the same

  2. No, different facts should be stored in different tables

  3. Depends on individual measure

  4. Can't say
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Two facts based on the same dimensions can be stored in the same fact table as long as they share the exact same level of detail (granularity).

Keep practicing — related questions