FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Fact tables are which of the following?
A
Completely denoralized
B
Partially denoralized
C
Completely normalized
D
Partially normalized
Explanation: 

Detailed explanation-1: -To get the textual information about a transaction (each record in the fact table), you have to join the fact table with the dimension table. Some say that fact table is in denormalized structure as it might contain the duplicate foreign keys.

Detailed explanation-2: -A fact table stores quantitative information for analysis and is often denormalized.

Detailed explanation-3: -To normalise a fact table means we make it slim and tall. We do that by introducing a new dimension called “measure type” into the fact table, and move all measures into just one measure column: amount. The meaning of this amount column depends on the value of the measure type key.

Detailed explanation-4: -The fact table(s) will probably be the most normalized since they usually contain just numerical values along with various id’s for linking to dimensions. They key with fact tables is how granular do you need to get with your data.

Detailed explanation-5: -Star schema dimension tables are not normalized; snowflake schemas dimension tables are normalized. Snowflake schemas will use less space to store dimension tables but are more complex. Star schemas will only join the fact table with the dimension tables, leading to simpler, faster SQL queries.

There is 1 question to complete.