Physical Modeling › Teradata Physical Property Editors › Specify Teradata Conversion Routines (Casts)

Specify Teradata Conversion Routines (Casts)

You can use the Cast editor to specify a bi-directional conversion from one data type to another in a Teradata physical model.

To specify Teradata conversion routines

1. Click Casts on the Database menu.

   The Cast Editor opens.

2. Select a cast and work with the following options:

   Note: Click New on the toolbar to create a new cast.

   Name

   Specifies the name of the available casts.

   Source Datatype

   Specifies which properties are being used for the source. Select from the drop-down.

   Target Datatype

   Specifies which properties are being used for the target. Select from the drop-down.

   Use Replace Syntax

   Lets you select whether Forward Engineering uses the REPLACE command instead of the CREATE command.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Complete the following fields on the General tab:

   Procedure Type

   Specify the type of mapping for this object. This effects how the DDL generates during Forward Engineering. Select the type from the drop-down. Valid values are: Specific Method, Instance Method, Specific Function, and Function.

   Procedure

   Specifies the method or function used to perform the cast. Select from the drop-down.

   As Assignment

   Select the check box to implicitly invoke the cast functionality upon assignment.

4. (Optional) Click the Comment tab and enter any comments you want associated with the cast.
5. (Optional) Click the UDP tab to work with user-defined properties for the cast.
6. Click Close.

   The Cast Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor