Previous Topic: Create a MappingNext Topic: Apply Data Type Standards to a Model


Data Type Mapping Rules

Data Type mapping rules are used to convert data types. For example, in the following scenarios, you will see that data type mapping rules are used to determine if the data type result includes parentheses.

If the source data type has parameters for length, and the target data type has mandatory or optional parameters for length, the data type result includes the source data type's parameters, as follows:

Source Data Type

char(18)

Target Data Type

char()

Data Type Result

char(18)

If the source data type has parameters for length, and the target data type has no parameters for length, the data type result does not include parameters, as follows:

Source Data Type

char(18)

Target Data Type

char

Data Type Result

char

If the source data type has no parameters for length, and the target data type has mandatory parameters for length, the data type result includes parameters with the default value of 100, as follows:

Source Data Type

char

Target Data Type

char()

Data Type Result

char(100)

If the source data type has no parameters for length, and the target data type has optional or no parameters for length, the data type result has no parameters, as follows:

Source Data Type

char

Target Data Type

char() or char

Data Type Result

char