Effective Study Techniques for the SAS Institute A00-260 Exam

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

Create and replace permanent tables.

Maintain access privileges to permanent tables.

Apply and maintain constraints on permanent tables.

Delete and remove permanent tables.

The name of the option has to start with _REQUIRED.

The type of the column has to be defined as Required Data source column.

The option can be marked as Requires a non-blank value.

It is not possible to make an option required.

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.

Data Validation

Lookup

DataFlux IS Job

Table Loader

Loads source table records into a standardization table.

Loads dimension table records into a fact table.

Loads source table records into a dimension table.

Loads fact table records into a multi-threaded table.

Append

Extract

Lookup

Mining Results

metadata objects across metadata servers

metadata objects within a logged on user's personal folder

metadata objects within a metadata server

metadata objects within a logged on user's Checkouts Tree

in the source and standardization tables

in the source and dimension tables

in the target and fact tables

in the source, dimension and standardization tables

To schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.

To schedule the job on the Platform Process Manager you require a dependency generator.

Multiple job flows can be scheduled to a deployment directory.

To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data

Integration Studio.