174k views
5 votes
Dimension Tables: Small tables with _____ number of records compared to facts

User Arta
by
7.4k points

1 Answer

0 votes

Final answer:

Dimension Tables are small tables that contain a limited number of records compared to facts. They are used in data warehousing and business intelligence to provide descriptive attributes for the facts stored in larger fact tables.

Step-by-step explanation:

Dimension Tables are small tables that contain a limited number of records compared to facts. They are used in data warehousing and business intelligence to provide descriptive attributes for the facts stored in larger fact tables. For example, in a sales database, a dimension table for products may contain information like product name, category, and price. This dimension table would have a smaller number of records compared to the fact table that stores details about each sale.

User Ipor Sircer
by
6.6k points