Chapter 7 Data Transformations Basics


Transformation process properties

You can modify an object's properties from its property sheet. To open a transformation process property sheet, double-click its diagram symbol or its Browser entry in the Transformation Processes folder.

The General tab contains the following properties:

Property Description
Name Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users.
Code Specifies the technical name of the item, which is used for generating code or scripts.
Comment Specifies a descriptive comment for the object.
Stereotype Extends the semantics of an object derived from existing objects but specific to your needs. You can type stereotypes directly in this field, or add stereotypes to the list by specifying them in your model's resource file or in an extended model definition.
Server Name of the server on which the transformation process is deployed. You can use the tools to the right of the list to create an object, browse the complete tree of available objects or view the properties of the currently selected object.
Type Type of the engine you are using specified in an extended model definition (XEM). It influences the generation and the display of additional information within specific tabs. If you change the type, the data types used by the data structure columns that exist beneath in the different transformation steps will be converted to their equivalents in the new transformation engine. This conversion also applies to SQL functions used to build the source expression of data structure columns. For more information about data types, see Script/Data Type Category in the DBMS Resource File Reference chapter of the Customizing and Extending PowerDesigner manual. For more information about SQL functions, see Keyword category in the same chapter.

 


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