A00-260 practice question 14 of 15
In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?
Full set: 70 questionsThe Lookup transformation in SAS Data Integration Studio is specifically designed to combine data from a source table with data from one or more dimension (or lookup) tables. It matches records between the source and dimension tables based on a specified key. For each matching record in the source table, it retrieves corresponding columns from the dimension table and appends them to the output data set. This process enriches the source data with descriptive attributes from the dimension table, which is a fundamental operation in building data warehouses and marts.
A. Data Validation: This transformation is used to enforce business rules and check data quality, not to combine records from different tables for output.
C. DataFlux IS Job: This transformation executes a pre-built DataFlux Data Management Studio job. While that job could perform a lookup, this transformation itself is an execution wrapper, not the primary tool for combining tables.
D. Table Loader: This transformation is used to load data from a single source into a target table. Its purpose is data loading, not joining or combining data from multiple sources.
1. SAS Institute Inc. (2017). SAS Data Integration Studio 4.9: User's Guide.
Chapter 23, "Working with Transformations," Section: "Lookup Transformation," p. 489: "The Lookup transformation enables you to perform a lookup operation on a source table. The lookup can be performed on one or more lookup tables." This directly supports the correct answer.
Chapter 23, "Working with Transformations," Section: "Data Validation Transformation," p. 469: "The Data Validation transformation enables you to validate the data in a source table based on a set of rules that you specify." This confirms option A is incorrect.
Chapter 23, "Working with Transformations," Section: "DataFlux IS Job Transformation," p. 468: "The DataFlux IS Job transformation enables you to run a DataFlux Integration Server job from a SAS Data Integration Studio job." This confirms option C is an execution tool, not a combining tool.
Chapter 23, "Working with Transformations," Section: "Table Loader Transformation," p. 533: "The Table Loader transformation enables you to select a load style and load a source table into a single target table." This confirms option D is for loading, not combining.
Keep practicing
Take the free A00-260 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-260 practice questions
- Question 1Which statement regarding scheduling SAS Data Integration Studio jobs is true?
- Question 3Assume that you have completed the Register Tables wizard in SAS Data Integration Studio.…
- Question 4Assume that SAS Data Integration Studio Table Loader is being used in a job. The load sty…
- Question 5When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can b…
- Question 6The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored …
- Question 7Which statement correctly defines a System DSN?
