No. The Extract transformation does not have a status handling tab in its Properties window, and the Return Code Check transformation can only provide status handling at the job level.

Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

No. The Extract transformation does not have a Status Handling tab in its Properties window, therefore it is not possible to establish status handling for this transformation.

Yes. The Return Code Check transformation can be added to the job flow immediately following the Extract - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

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

Data Transfer

Data Validation

Data Quality

Data Extract

business key columns

Type 1 columns

generated columns

non-key columns

A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.

A location in the metadata repository where job flows are deployed.

A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows.

A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.

SAS macro variables

columns of SAS datasets

SAS formats

SAS macro calls

in dfPower Profile (Viewer)

in the Reports tab of dfPower Profile (Configurator)

in any HTML viewer

in any text viewer

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.

An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call

dfPower Architect or dfPower Profile jobs.

A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing

operations.

An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for

data cleansing operations.

A third party server defined in the SAS metadata repository that allows you to build flows integrating

multiple jobs and establishing job dependencies within the flow.

Not specific to an individual user. Anyone with permission to access the data source can use it.

Specific to an individual user. It is available only to the user who creates it.

Not specific to an individual user. It can be shared among users even though it is created locally.

Specific to an individual user. But it can be shared among users.