Data Source Table Columns H

Data Source Table Columns V

Use this page to Modify Configuration of Data Source Table Columns.

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 View Design.
  8. Click Column Count for a data source table.

Data Source Table Columns V

Data Source Table Columns H

Use this page to Modify Configuration of Data Source Table Columns.
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.