Question

differentiate between reference table and summary table

Answer 1

1.The fact table mainly consists of business facts and foreign keys that refer to primary keys in the dimension tables. A dimension table consists mainly of descriptive attributes that are textual fields. 2.A dimension table contains a surrogate key, natural key, and a set of attributes.

souce:internet..

plz mark it as brainliest..

hope u like it..❤❤