Collect

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.