Chapter 5 Working with Information Liquidity Models


Data output checks

The following ILM model checks are made on data outputs (database output, XML output, flat file output, generic data output):

Check Description and Correction
Data output name and code uniqueness Data output names and codes must be unique in the namespace [model or package].

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code
Existence of data connection A data output must be linked to a data connection.

Manual correction: Select a data connection in the Data Connection list of the property sheet

Automatic correction: None
Existence of source object A data output must have at least one data structure source object.

Manual correction: Add any missing source objects in the Data Structure Source Objects tab of the data output.

Automatic correction: None
Existence of data structure column At least one data structure column must be defined in the data output.

Manual correction: Add any missing data structure columns in the Data Structure Columns tab of the data output.

Automatic correction: None
Existence of target object A data output must have at least one data structure target object.

Manual correction: Add any missing target objects in the Data Structure Target Objects tab of the data output.

Automatic correction: None
Data structure mismatch The data type between the data structure column and its source objects must match

Manual correction: Set the same data type for the data structure column and its source objects.

Automatic correction: None

 


Copyright (C) 2007. Sybase Inc. All rights reserved.