Collect

Connection Type Data Conversion H

Connection Type Data Conversion V

Use this page to Set Up Connection Types.

To access this page:

  1. Select Collect > Administrative > Connection Types in Navigation pane.
  2. Click Sources for SQL SERVER Target Connection Type.
  3. Click Data Type Conversions.

Field

Description

PROCESS ORDER

Displays order that rules are run.

DATA VALIDATE CONTROL

Displays a rule that validates data. This process is used when the Build Package process is run to create the target table.

PROCESS FLAG

Displays a way in which data is processed.

Values are:

  • Accept - Use to load the field into the target table.
  • Error - Use to stop the build process and to display the field as not having a data type conversion issue.
  • Ignore - Use to not create the field in the target table.

DATA TYPE

Displays type of data in the source.

DATA LENGTH

Displays length of data in the source.

NEW DATA TYPE FORMAT

Displays format for new type of data to be defined in target. Includes length or scale.

SYSTEM SUPPLIED

If checked, the Source Connection Data Type Conversion was delivered with the product and cannot be deleted.

This check box cannot be updated.

If unchecked, the data type conversion was added as a custom conversion.

Connection Type Data Conversion V

Connection Type Data Conversion H

Use this page to Set Up Connection Types.

Field

Description

Process Order

Displays order that rules are run.

Data Validate Control

Displays a rule that validates data. This process is used when the Build Package process is run to create the target table.

Data Type

Displays type of data in the source.

Data Length

Displays length of data in the source.

Data Precision

Displays data precision of field (total number of digits) in source.

Data Scale

Displays data scale of field (number of digits after decimal point) in source.

New Data Type Format

Displays format for new type of data to be defined in target. Includes length or scale.

New Data Type

Displays new data type of field in target.

New Data Length

Displays new length of field in target. 

New Data Precision

Displays new data precision of field (total number of digits) in target.

New Data Scale

Displays new data scale of field (number of digits after decimal point) in target.

Process Flag

Displays a way in which data is processed.

Values are:

  • Accept - Use to load the field into the target table.
  • Error - Use to stop the build process and to display the field as not having a data type conversion issue.
  • Ignore - Use to not create the field in the target table.

Column Override Template

Displays column name used to convert a source column into a new format in the target.