Properties
The fields in the Database Link Load Properties screen are described below:
Fields | Description |
|---|---|
Load Table Name | The table name is limited by most relational databases to a maximum of 30 characters and must be unique. Table name defaults can be set up in Tools > Options to define a prefix or a post-fix that can be added to identify clearly that this is a load table. Example: load_customer. By default, WhereScape RED uses the prefix load_ for Load tables. |
Unique Short Name | It must be unique. The short name is used in the naming of indexes, keys, procedures, and scripts. |
Description | Enter a description of the table. This description appears in the documentation that can be generated, once the data warehouse is built. |
Connection | Enter the connection being used to get the data. The connections for Load tables can be changed in bulk, refer to Changing load Connection and Schema for details. |
Load Type | The load type is typically defined by the connection, and should not normally be changed. This drop-down shows all valid load types for the connection. |
Script Connection | Select the connection for the script. |
Script Template | The script template used for a script-based load. |
Script Name | This field is only active for script-based loads. When doing a Script-based load, use the Rebuild button after selecting the relevant script to be rebuilt from the Script Name drop-down list. |
Pre-load Action | Select an action to be performed on the table before the load occurs. Options are:
|
Pre-load SQL | If a Pre-load Action of Execute pre-load Sql was selected, then the SQL statement to execute before the load takes place should be entered in this box. |
Table Properties clauses (e.g. Partition) | These are clauses that are added to the end of the table create statement. Typically used for putting partition information on the table. |
Post Load Type | This field is only available for custom database targets Enables you to specify the type of post load to execute for the table. Options are Procedure or Script. |
Post Load Procedure | A procedure that is executed immediately following the load. If you execute an externally loaded table, no load occurs, but a post-load procedure can still be executed. Post-load procedures can either be manually generated from a RED-provided procedure outline or generated using a RED template—refer to Rebuilding Update Procedures for details. This field is only available for custom database targets and is only displayed when the Script option is selected from the Post Load Type field above. A script that is executed immediately following the load. If you execute an externally loaded table, no load occurs but a post-load script can still be executed. Post-load scripts can be generated using a RED template—refer to Rebuilding Update Procedures for details. | |
Three fields at the bottom of the Load Table Properties screen display date information:
- Date table structure last updated.
- Date created in database.
- Date last updated in database.
Source Mapping
The fields in the Database Link Load Source Screen are described below:
Load Type | Method of loading data into the table. The available options are dependent on the Source Connection. Defaults to the Default Load Type of the Source Connection. Can be specified via the table Properties window. |
Source Connection | The connection that identifies the source database. Can be specified via the table Properties window. |