Fact tables are which of the following ........

Computer GK DBMS

Download Solution PDF

Fact tables are which of the following?

Completely demoralized

Partially demoralized

Completely normalized

Partially normalized

छोटे Courses बड़े Results

Master DBMS

Prepare through Micro-courses

Try Now

Explanation:

Answer: (c). Completely normalized .

The fact table is in normalized structure as the redundant information is maintained in the dimension tables. The fact table contains foreign keys to the dimension tables. 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.