In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

Question

Options

• AData Validation
• BLookup
• CDataFlux IS Job
• DTable Loader

• A
  2% (1)
• B
  87% (41)
• C
  4% (2)
• D
  6% (3)

Explanation

Lookup is correct because it is specifically designed to join records from a source (fact) table with matching records from a dimension (reference) table, enriching the output with additional attributes - exactly the pattern used in data warehousing ETL flows.

• A. Data Validation checks data quality rules (nulls, ranges, formats) but does not combine records from two tables.
• C. DataFlux IS Job integrates DataFlux data quality jobs into a SAS DI Studio process flow; it handles cleansing, not table joining.
• D. Table Loader writes transformed data to a target table - it's the destination step, not a joining mechanism.

Memory tip: Think of a "lookup" as looking something up in a reference book (the dimension table) to add details to what you already have (the source record) - same concept, same name.

No community discussion yet for this question.