Chapter 10 Building Data Transformation Diagrams


Data structure column General tab

The General tab contains the following properties:

Property Description
Name The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users.
Code The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces.
Comment Descriptive comment for the data structure column.
Stereotype Extends the semantics of an object derived from existing objects but specific to your needs. You can type stereotypes directly in the Stereotype box of the object property sheet or select a value from the list if you have previously defined stereotypes in an embedded or imported extended model definition (.XEM).
Data type Form of the data corresponding to the column, such as numeric, alphanumeric, boolean, or others
length Maximum length of the data type
Precision Maximum number of places after the decimal point
Mandatory When selected, indicates a column that must be assigned a not null value
Default value Type a default value for the data structure column
Identifier When selected, indicates that the data structure column is an identifier. This is useful when you update the target tables used to create a join
Target object [Only available when the data structure column is owned by a data output] Target object in which the data structure column is loaded. You can use the tools to the right of the list to browse the complete tree of available objects or view the properties of the currently selected object

 


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