Which action is performed by the Lookup transformation in SAS Data Integration Studio?

Question

Options

• Acombines rows from multiple tables into a single row
• Bcombines rows from multiple tables into multiple rows
• Cvalidates that values are unique
• Dvalidates that values are not null

• A
  86% (31)
• B
  8% (3)
• C
  3% (1)
• D
  3% (1)

Explanation

The Lookup transformation in SAS Data Integration Studio performs a table join-style operation where it matches rows from a lookup (reference) table to rows in a source table and merges the matched data into a single output row - combining columns from multiple tables into one row per match (option A).

• B is wrong because producing multiple rows per source record describes a behavior more like a one-to-many join or a Cartesian product, not a Lookup.
• C is wrong because validating uniqueness is the role of the SCD (Slowly Changing Dimension) or Data Validation transformations, not Lookup.
• D is wrong because null validation is handled by transformations like Data Quality or explicit Where clause filters, not Lookup.

Memory tip: Think of Lookup like looking something up in a dictionary - you bring one source record together with its matching reference data into a single, enriched row. One lookup → one richer row.

No community discussion yet for this question.