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 dimension table in data warehousing?
Open an interactive chat with Bash
What does it mean to capture historical data in a dimension table?
Open an interactive chat with Bash
What are the implications of replacing data in dimension tables?