What are the two types of tables involved in producing a star schema?

Options
- Fact tables and user tables
- Dimension tables and error tables
- Fact tables and dimension tables
- User tables and error tables


CORRECT ANSWER : Fact tables and dimension tables

Discussion Board
practice

practice

himesh 09-16-2017 03:11 AM

Fact table and Dimension table

Fact tables and dimension tables are involved in producing a star schema. A fact table is the central table in a star schema of a data warehouse. A fact table stores quantitative information for analysis and is often denormalized. Dimension tables provide descriptive or contextual information for the measurement of a fact table. On the other hand, fact tables provide the measurement of an enterprise. Dimension table and fact table are mainly used in data warehousing. 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.

Prajakta Pandit 02-8-2017 11:11 PM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement