Data Source Tables H

Data Source Tables V

Use this page to Modify Configuration of Data Source Tables.

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.
Field Description
TABLE Displays table in source.
TARGET Displays database where tables are refreshed with source data.
SOURCE Displays database where data is refreshed from and stored in the target.
PACKAGE NAME Displays name of package that refreshes target table with source data.
BUILT COUNT Displays the number of times the package has been built.
Column Count Displays number of columns in source table. Click link to open the Data Source Table Columnspage to add, edit and delete columns within source table.
SQL Command Click to open the Data Source Table Create Download SQLpage to edit and delete SQL commands in the package.

Data Source Tables V

Data Source Tables H

Use this page to Modify Configuration of Data Source Tables.
Field Description
Target Displays database where tables are refreshed with source data.
Source Displays database where data is refreshed from and stored in the target.
Table Displays table in source.
Table Rename Displays table name of renamed table in target. New table name must contain [TableName]. At run time, [TableName] is replaced with processing table name.
Package Name Displays name of package that refreshes target table with source data.
Target Time Out Displays time out period, in seconds, for the target. Default value is 180 (3 minutes).
Source Time Out Displays time out period, in seconds, for the source. Default value is 300 (5 minutes).
Built Count Displays the number of times the package has been built.