Data Warehousing Question:

Download Job Interview Questions and Answers PDF

What is hybrid slowly changing dimension?

Data Warehousing Interview Question
Data Warehousing Interview Question

Answer:

Hybrid SCDs are 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 don't care.For such tables we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.You can add that it is not an intelligent key but similar to a sequence number and tied to a timestamp typically!

Download Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
How many clustered indexes can u create for a table in DWH? In case of truncate and delete command what happens to table, which has unique id.Can a dimension table contain numeric values?