In a fact table, each record represents a _______ at a specific level of detail.
- Entity
- Event
- Relationship
- Transaction
In a fact table, each record represents a transaction at a specific level of detail. A fact table contains quantitative data, such as measurements or metrics, and is typically associated with a timestamp to capture when the transaction occurred. This helps in analyzing and understanding the details of specific events or transactions in the dataset.
Loading...
Related Quiz
- _______ is a technique used in NoSQL databases to reconcile conflicting versions of data during eventual consistency.
- Data partitioning is often used to improve _______ in distributed systems.
- What are some potential drawbacks of denormalization?
- What are the key differences between a fact table and a transactional table in a relational database?
- What is a subtype in an ERD representing an inheritance hierarchy?