• +91 9723535972
  • info@interviewmaterial.com

Data Warehouse Interview Questions and Answers

Question - What is hybrid SCD?

Answer -

Hybrid SCDs are combinations of both SCD1 and SCD2. It may happen that in a table, some columns are important and need to track changes for them that are captured by the historical data for them. Whereas in some columns, even if the data changes, that does not need to bother. For such tables are implemented hybrid SCDs wherein some columns are of type 1, and some are of type 2. So basically, a blanket rule is not applied on the entire table rather than customized on which particular columns where a particular rule needed to be applied.

Comment(S)

Show all Coment

Leave a Comment




NCERT Solutions

 

Share your email for latest updates

Name:
Email:

Our partners