Answer Posted / Rishish Mishra
In Oracle Data Integration, there are three types of Slowly Changing Dimensions (SCD): SCD Type 1 - Overwrite (replaces all existing values with new ones), SCD Type 2 - Add/Update (maintains historical versions with a timestamp column), and SCD Type 3 - Add/Update/Active (keeps active, inactive, and historical versions of the data).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
