What do you mean by the term 'slowly changing dimension'?
Answer Posted / Ajeet Chaudhary
{"slowly changing dimension": "A dimension in a data warehouse that undergoes changes over time but does not require immediate updating of historical records. There are two types: Type 1 (overwrite) and Type 2 (add-row). In Type 1, the entire record is replaced with new values when it changes; in Type 2, a new row is inserted for the updated value while preserving the original data."}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers