A fact table is populated by using which transformation in SAS Data Integration Studio?

The correct answer is C. Lookup. Lookup is correct because, in SAS Data Integration Studio, the Lookup transformation retrieves matching values (typically surrogate keys) from dimension tables and uses them to populate the corresponding foreign key columns in a fact table - the core ETL step in building a…

Create and work with metadata for SAS Data Integration Studio

Question

Options

ASCD Type 2 Loader
BData Validation
CLookup
DDataFlux IS Job

How the community answered

(29 responses)

A
3% (1)
B
7% (2)
C
86% (25)
D
3% (1)

Explanation

Lookup is correct because, in SAS Data Integration Studio, the Lookup transformation retrieves matching values (typically surrogate keys) from dimension tables and uses them to populate the corresponding foreign key columns in a fact table - the core ETL step in building a dimensional data warehouse.

Why the others are wrong:

A (SCD Type 2 Loader) handles dimension tables, specifically tracking slowly changing dimension history - not fact tables.
B (Data Validation) checks data quality rules (nulls, ranges, patterns) and flags errors; it does not load or populate tables.
D (DataFlux IS Job) runs DataFlux data quality jobs and is unrelated to fact table population logic.

Memory tip: Think of it this way - you look up dimension keys and plug them into the fact table. The word "Lookup" maps directly to the act of resolving dimension references that give a fact table its meaning.

Topics

#Lookup transformation#Fact tables#SAS DIS#Data warehouse ETL

Community Discussion

No community discussion yet for this question.

Full A00-260 Practice