Pass the SAS Institute Data Integration Developer A00-260 Questions and answers with CertsForce

Automatic propagation can be set globally, so every new job will automatically propagate.

Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from

the end to the beginning is not available.

Automatic propagation that is set globally can be overridden and disabled within a job.

Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected

transformation.

The Data Validation transformation can generate match codes to provide de-duplication capabilities.

The Data Validation transformation can perform missing-value detection and invalid-value validation in a

single pass of the data.

The Data Validation transformation provides de-duplication capabilities.

The Data Validation transformation provides error-condition handling.

SAS metadata that describes how to collect and store data sources.

A document that stores the steps and locations for building a data mart.

A SAS program that is stored on the server and described by metadata.

A user written SAS PROC step.

It will become empty and all new and checked out metadata objects will revert to the not checked out state.

It will only contain the new metadata objects. All checked out metadata objects will revert to the not checked

out state.

It will become empty and the DI job called "Create Tables" will no longer be in a checked out state.

It will become empty and will not be accessible until the administrator grants permissions for it to be used

again.

You can control the removal and/or creation of indexes and constraints in the target table only if you are

using a Load style other than Replace.

You can control the removal and/or creation of indexes and constraints in the target table for all Load

Styles.

If using the Append to Existing load style, indexes and constraints can be added but not removed.

For the Update/Insert load style it is possible to remove indexes not required for the Update/Insert

processing, but no indexes can be added.

Data Validation

Lookup

DataFlux IS Job

Table Loader

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.

SAS macro variables

columns of SAS datasets

SAS formats

SAS macro calls

A comma delimited flat file that contains the field names in the first row.

Power scheme that is generated by Data Flux.

A SAS table scheme that is generated by SAS.

A third party RDBMS table that has been generated by the SAS system.

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.