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.