Collect

Data Source Table Create Download SQL H

Data Source Table Create Download SQL V

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

Field

Description

Table

Displays name of the 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 (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