A00-260 SAS Data Integration Development Questions and Answers

in metadata

on any machine that SAS Data Integration Studio can write to

in a SAS catalog

only on the machine where SAS Data Integration Studio is running

A transformation can have zero or more inputs and exactly one output.

A transformation needs at least one input and at least one output.

A transformation can have zero or more inputs and zero or more outputs.

A transformation needs at least one input and exactly one output.

Delimited

Fixed Width

User Written

COBOL Copybook

the Load Technique tab in the Table Loader transformation properties window

the Indexes tab in the table properties window

the Columns tab in the table properties window

the Columns tab in the Details panel of the open job, with the table selected in the job flow

Indexes are removed when the Table Loader executes and must be re-created using the Table Structure

transformation.

Indexes are automatically preserved when the Table Loader executes.

Indexes are removed at the beginning of the load process and must be re-created in a subsequent job step.

Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional

table loader options specify whether to re-create the index at the end of the process.

combines rows from multiple tables into a single row

combines rows from multiple tables into multiple rows

validates that values are unique

validates that values are not null

SAS packages are used to import and export SAS applications.

SAS packages are used to import and export stand-alone SAS programs.

SAS packages are used to import and export third-party metadata.

SAS packages are used to import and export SAS metadata.