Describe dimension tables and fact tables

Briefly describe the term dimension tables and fact tables?

E

Expert

Verified

Business facts or appraises and foreign keys are persevered in fact tables that are referred as candidate keys in dimension tables. Additive values are usually given by the fact tables that act as self-governing variables through which dimensional Attributes are examined.

Attributes that are employed to restrain and group data for performing data warehousing doubts are persevered in the dimension tables.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.