Collect

Data Source Table Columns H

Data Source Table Columns V

To access this page:

  1. Click Collect > Targets in the Navigation pane.
  2. Click Sources for a target.
  3. Click Schedule Groups for a source.
  4. Click Tables for a schedule group.
  5. Click Vertical View for a table.
  6. Click General Information tab.
  7. Click the Columns icon for a table.

Field

Description

COLUMN

Displays the column converted to the defined data type and loaded into the target table.

FROM DATA TYPE

Displays data type of field in the source.

FROM DATA LENGTH

Displays data length of field in the source.

FROM DATA SCALE

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

TABLE CREATE DATA TYPE

Displays definition used in SQL Server to create tables in the target.

COLUMN OVERRIDE

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

NOTE: The Column Override field allows for source system function commands to be overridden when data is loaded into the target SQL server tables, for example, TO_CHAR(ORDER_TIMESTAMP,’YYYYMMDD’) as Order_Timestamp.

COLUMN ORDER

Displays the exact order of columns within the table. This value can get large because it’s a unique value for all tables and columns.

Data Source Table Columns V

Data Source Table Columns H

Field

Description

Column

Displays the column converted to the defined data type and loaded into the target table.

From Data Type

Displays data type of field in the source.

From Data Length

Displays data length of field in the source.

From Data Precision

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

From Data Scale

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

From Nullable

Displays nullable flag of field in the source.

Table Create Data Type

Displays data type to create tables in the database.

To Data Type

Displays new data type of field in the target.

To Data Length

Displays new data length of field in the target.

To Data Precision

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

To Data Scale

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

To Nullable

Displays new nullable flag of field in the target.

Column Override

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

Column Order

Displays exact order of columns within the table. This value can get large because it’s a unique value for all tables and columns.