Collect

Column Table List in Source Target

Use this page to view the Column Table List in Source Target report.

To access this page:

  1. Select Collect > Reports in the Navigation pane.
  2. Click Column Table List in Source Target on the Reports page.

Field

Description

COLUMN

Displays the column Collect found in the source database that matches the data type conversion being accepted. This is the table name that will be in the target database.

TABLE

Displays the table name in the source database and target database.

SOURCE

Displays the database where the data is refreshed from and stored in the target.

TARGET

Displays the database target where tables are refreshed with source data.

FROM DATA TYPE

Displays the data type of the field in the source.

FROM DATA LENGTH

Displays the data length of the field in the source.

FROM DATA PRECISION

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

FROM DATA SCALE

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

FROM NULLABLE

Displays the nullable flag of the field in the source.

TO DATA TYPE

Displays the new data type of the field in the target.

TO DATA LENGTH

Displays the new data length of the field in the target.

TO DATA PRECISION

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

TO DATA SCALE

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

TO NULLABLE

Displays the new nullable flag of the field in the target.

COLUMN OVERRIDE

Displays the source system SQL function or command to download data from the source.