In the context of healthcare data warehousing, what is a 'slowly changing dimension' (SCD) Type 2?
-
A
Maintaining full history by adding a new row for each change
-
B
Overwriting the existing record with new values
-
C
Storing both old and new values in the same row
-
D
Ignoring historical changes and keeping only current values