Tell us what are the different types of SCD's used in data warehousing?
Submitted by: MuhammadSCD (Slowly changing dimensions), are the dimensions in which the data changes slowly, rather than changing regularly on a time basis.
Three types of SCDs are used in data warehousing, which are defined as:
☛ – SCD1: It is a record that is used to replace the original record even there is only one record existing in the database. The current data will be replaced and the new data will take its place.
☛ – SCD2: It is the new record file that is added to the dimension table. This record exists in the database with the current data and previous data that is stored in the history.
☛ – SCD3: This uses the original data that is modified to the new data. This consists of two records: one record that exist in the database and another record that will replace the old database record with the new information.
Submitted by: Muhammad
Three types of SCDs are used in data warehousing, which are defined as:
☛ – SCD1: It is a record that is used to replace the original record even there is only one record existing in the database. The current data will be replaced and the new data will take its place.
☛ – SCD2: It is the new record file that is added to the dimension table. This record exists in the database with the current data and previous data that is stored in the history.
☛ – SCD3: This uses the original data that is modified to the new data. This consists of two records: one record that exist in the database and another record that will replace the old database record with the new information.
Submitted by: Muhammad
Read Online Data Warehouse Developer Job Interview Questions And Answers
Top Data Warehouse Developer Questions
☺ | Explain me why is chameleon method used in data warehousing? |
☺ | Tell us what is Hybrid SCD? |
☺ | Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing? |
☺ | Can you list the Schema that a data warehouse system can implements? |
☺ | Tell us what is Virtual Warehouse? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |