In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

Question

Options

• Afind row matches using the business key
• Bfind row matches using generated cluster numbers
• Cfind non-standard values using a generated key
• Dfind non-standard values using a business key

• A
  93% (37)
• C
  3% (1)
• D
  5% (2)

Explanation

SCD Type 2 (Slowly Changing Dimension Type 2) is designed to preserve historical data by adding new rows when dimension attributes change. To do this, the loader must first identify which existing rows correspond to incoming source records - and it does this using the business key (a natural identifier like Customer ID or Product Code), not a surrogate key, because the surrogate key is generated internally and isn't available in the source system.

Option B is wrong because "generated cluster numbers" is a database storage/indexing concept entirely unrelated to SCD matching logic. Option C is wrong because SCD Type 2 doesn't search for "non-standard values" at all - it tracks attribute changes over time; also, using a generated key for matching is incorrect since generated keys are assigned by the target system and can't be used to join back to source data. Option D is wrong for the same "non-standard values" reason - that phrasing describes data quality/validation work, not dimension history tracking.

Memory tip: Think "SCD Type 2 uses the key YOU gave it (business key), not the key IT made up (surrogate key)." The business key is the stable, real-world identifier that ties source to target across loads.

No community discussion yet for this question.