Data Warehouse Developer Question:
Download Job Interview Questions and Answers PDF
Tell us what is Hybrid SCD?
Answer:
Hybrid SCDs are a combination of both SCD 1 and SCD 2.
It may happen that in a table, some columns are important and we need to track changes for them i.e., capture the historical data for them whereas in some columns even if the data changes, we do not have to bother.
For such tables, we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.
It may happen that in a table, some columns are important and we need to track changes for them i.e., capture the historical data for them whereas in some columns even if the data changes, we do not have to bother.
For such tables, we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.
Download Data Warehouse Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me why is chameleon method used in data warehousing? | Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing? |