Collect

Data Source Table Create Download SQL H

Data Source Table Create Download SQL V

Use this page to View Configuration of Data Source Table SQL Commands.

To access this page:

  1. Click Collect > Targets on 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 SQL Command for a table.

Field

Description

TABLE

Displays name of table refreshed from source to target.

SQL COMMAND

Displays the SQL commands that are run when the table is created on a build or download process.

RECORD TYPE

Displays the type of record (as in, the SQL command).

Values are:

  • Clustered Index - Creates a cluster index on the target table
  • Create Table - Creates the table in the target database
  • Indexes - Creates an index on the target table
  • Primary Key - Creates the primary key on the target table
  • Select Table - Selects * from the source table

Data Source Table Create Download SQL V

Data Source Table Create Download SQL H

Use this page to View Configuration of Data Source Table SQL Commands.

Field

Description

Target

Displays the database where tables are refreshed with source data.

Source

Displays the database where data is refreshed from and stored in the target.

Table

Displays name of the table refreshed from source to target.

Record Type

Displays the type of record (i.e., the SQL command).

Values are:

  • Clustered Index - Creates a cluster index on the target table
  • Create Table - Creates the table in the target database
  • Indexes - Creates an index on the target table
  • Primary Key - Creates the primary key on the target table
  • Select Table - Selects * from the source table

Record Order

Displays logical sort order of records in the table.

SQL Command

Displays the SQL commands that are run when the table is created on a build or download process.