A data analyst is designing a dimension table to track customer address history. The design requires that when a customer's address changes, a new row is added with the updated address, while the previous address record is retained for historical analysis. Which of the following concepts is being implemented?
The correct answer describes a Slowly Changing Dimension (SCD) Type 2. This approach preserves history by creating a new record for each change to a specific attribute, which allows for historical tracking. SCD Type 1 would overwrite the existing record, losing the historical data. Online Transactional Processing (OLTP) systems are typically sources of data for a data warehouse but do not describe this method of managing historical data. A star schema is a database organizational model and not a method for handling attribute changes within a dimension.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a Slowly Changing Dimension (SCD)?
Open an interactive chat with Bash
How does a Slowly Changing Dimension (SCD) Type 2 differ from SCD Type 1?
Open an interactive chat with Bash
What is the role of dimension tables in data warehouses?