Column name.

The column names in the target. When editing a relational target definition, edit the column name if you are manually creating the relational target definition or if the actual target column name changed.

Datatype.

The datatypes that display in the target definition depend on the target type of the target definition.

Precision and scale.

When designing or importing relational targets, consider the precision and scale of values in each column.

Precision

is the maximum number of significant digits for numeric datatypes, or the maximum number of characters for string datatypes. Precision includes scale.

Scale

is the maximum number of digits after the decimal point for numeric values. Therefore, the value 11.47 has a precision of 4 and a scale of 2. The string

Informatica

has a precision (or length) of 11.

All datatypes for relational targets have a maximum precision. For example, the Integer datatype has a maximum precision of 10 digits. Some numeric datatypes have a similar limit on the scale or do not allow you to set the scale beyond 0. Integers, for example, have a scale of 0, since by definition they never include decimal values.

You can change the precision and scale for some datatypes to values that differ from the values defined in the database. However, changing the precision or scale can cause numeric overflow on numeric columns, truncation on character columns, or insertion of zeroes on datetime columns when the Integration Service writes to the target column.

Not null.

Choose whether you want to allow null data in the target.

Key type.

Select Primary, Foreign, Primary-Foreign, or Not a Key. Applies to relational targets only.

Business name.

Optionally, you can add business names to each target column.