In Slowly Changing Dimensions (SCD), which technique is commonly used to maintain historical data in a dimension table?
- Delete
- Hybrid
- Insert
- Update
In Slowly Changing Dimensions (SCD), the Insert technique is commonly used to maintain historical data in a dimension table. With this technique, new records are inserted into the dimension table to represent changes, while existing records remain intact, preserving historical information.
Loading...
Related Quiz
- Microsoft Visio offers _______ templates for creating database diagrams.
- In document-based modeling, a document typically contains multiple _______.
- In a fact table, each record represents a _______ at a specific level of detail.
- A _______ key constraint ensures that values in a column or set of columns are unique across the entire table.
- The process of converting a high-level conceptual model into a detailed logical model involves _______.