UGC NET CS 2018-DEC Paper-2
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 597
|
Factless fact table in a data warehouse contains
|
only measures
|
|
|
only dimensions
|
|
|
keys and measures
|
|
|
only surrogate keys
|
Question 597 Explanation:
→ Factless fact table in a data warehouse contains only surrogate keys.
→ The factless fact table is a fact table that does not contain any facts. There are two kinds of factless fact tables:
1. Factless fact table describes event or activity.
2. Factless fact table describes a condition, eligibility or coverage.
→ The factless fact table is a fact table that does not contain any facts. There are two kinds of factless fact tables:
1. Factless fact table describes event or activity.
2. Factless fact table describes a condition, eligibility or coverage.
Correct Answer: D
Question 597 Explanation:
→ Factless fact table in a data warehouse contains only surrogate keys.
→ The factless fact table is a fact table that does not contain any facts. There are two kinds of factless fact tables:
1. Factless fact table describes event or activity.
2. Factless fact table describes a condition, eligibility or coverage.
→ The factless fact table is a fact table that does not contain any facts. There are two kinds of factless fact tables:
1. Factless fact table describes event or activity.
2. Factless fact table describes a condition, eligibility or coverage.