Question - What are the different types of SCDs used in data warehousing?
Answer -
SCDs stands for slowly changing dimensions. It is basically a dimension where data changes do not happen frequently or on any regular basis. There are three types of SCDs the first is SCD1 it is a record that is used to replace the original record. Even when there is only one record existing within the database, the present data is going to be replaced, and therefore the new data will take its place.
SCD2 is the new record file that is added to the dimension table. The record exists in the database with the current data and the previous data that is stored in the audit or history.
SCD3 uses the original data that is modified to the new data. This consists of two records, one record that exists in the database and the other record which will replace the old database record with this new information.