The process of aggregating data from various sources into a fact table is known as _______.
- Aggregation
- Denormalization
- Indexing
- Normalization
The process of aggregating data from various sources into a fact table is known as Aggregation. This involves summarizing and combining data to provide a more comprehensive view for analysis. Aggregation is a key step in data warehousing, enabling efficient reporting and analysis of large datasets.
Loading...
Related Quiz
- Scenario: A database contains a table where the primary key consists of {OrderID, ProductID}, and there is an attribute called ProductDescription. Is this table in the second normal form (2NF)?
- What is the purpose of sharding in NoSQL databases?
- What is the main output of conceptual schema design?
- Clustering helps to group similar data _______ for efficient retrieval.
- The _______ of a relationship indicates the maximum number of occurrences of one entity that can be associated with each occurrence of another entity.