Can the same fact with different aggregate layers be put in the same table

  1. As long as the aggregate facts refer to keys in appropriate layer in the dimsension

  2. Multiple aggregate levels can be stored in different tables

  3. Aggregated facts should not be stored in the physical tables, they must always be calculated on the fly

  4. A and B

  5. All of the above


Correct Option: A,B,D

Find more quizzes: