Scenario: A healthcare organization needs to maintain historical records of patient demographics, including changes in address and contact information. Which SCD type would be most suitable for this scenario?

  • Type 1 SCD
  • Type 2 SCD
  • Type 3 SCD
  • Type 4 SCD
For maintaining historical records of patient demographics, including changes in address and contact information, Type 2 Slowly Changing Dimensions (SCD) is most suitable. It allows the creation of new records for each change, preserving the history of patient details over time without modifying the original record.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *