The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

Question

Options

• ALoads source table records into a standardization table.
• BLoads dimension table records into a fact table.
• CLoads source table records into a dimension table.
• DLoads fact table records into a multi-threaded table.

• A
  7% (5)
• B
  4% (3)
• C
  87% (58)
• D
  1% (1)

Explanation

Option C is correct because the SCD (Slowly Changing Dimension) Type 2 Loader transformation in SAS Data Integration Studio is specifically designed to load source table records into a dimension table, maintaining historical changes by adding new rows with updated surrogate keys and effective date tracking rather than overwriting existing data.

• A is wrong because "standardization table" is not a real SAS DI Studio destination for this transformation - standardization is a data quality concept, not an SCD target.
• B is wrong because the SCD Type 2 Loader moves data into a dimension table, not from a dimension table into a fact table - that flow is handled by other ETL logic.
• D is wrong because "multi-threaded table" is not a standard SAS DI Studio concept or target object for any loader transformation.

Memory tip: Think of the acronym SCD - "Source to Changing Dimension." The Type 2 Loader's whole job is preserving history in a dimension table by tracking how source records change over time, so the flow is always source → dimension.

No community discussion yet for this question.