Data Transformation Task Checks

The following ILM model checks are made on data transformation tasks:

Check

Description and Correction

Data transformation task name and code uniqueness

Data transformation task names and codes must be unique in the namespace.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Existence of data transformation action

At least one data transformation action should be associated with the data transformation task.

Manual correction: Add any missing data transformation actions in the Actions tab of the data transformation action property sheet

Automatic correction: None

Existence of data input

At least one data input should be associated with the data transformation task.

Manual correction: Add any missing data inputs in the Inputs tab of the data transformation action property sheet

Automatic correction: None

Existence of data output

At least one data output should be associated with the data transformation task.

Manual correction: Add any missing data outputs in the Outputs tab of the data transformation action property sheet

Automatic correction: None

Existence of data flow

At data transformation task should contain at least one data flow between each transformation step in the data transformation diagram.

Manual correction: Add any missing data flows in the data transformation diagram

Automatic correction: None


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com