πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!

  • google app store apple app store
  • βœ–

      Question

      Which type of slowly changing dimension (SCD) preserves

      full history by adding a new row for each change and using effective date ranges?
      A Type 0 Correct Answer Incorrect Answer
      B Type 1 Correct Answer Incorrect Answer
      C Type 2 Correct Answer Incorrect Answer
      D Type 3 Correct Answer Incorrect Answer
      E Type 4 Correct Answer Incorrect Answer

      Solution

      SCD Type 2 preserves history by inserting new rows with new surrogate keys and storing effective/expiry dates or current flag.

      Practice Next
      ask-question