Load tables once defined would normally be created and loaded, unless these actions were performed as part of the drag-and-drop operation.
The menu below shows the operations that can be performed on Load tables.

Note

WhereScape RED supports the use of keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected table, pressing L performs an interactive load, etc. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.


Menu Options

Description

Properties

Displays the Properties window for the Load table, albeit focused on different tabs within this window.

Storage

Displays the Properties window for the Load table, albeit focused on different tabs within this window.

Source

Displays the Properties window for the Load table, albeit focused on different tabs within this window.

Display Columns

Displays columns of the load table.

Display Indexes

Displays indexes of the load table.

Display Data

Displays data of the load table.

Tip

If the data is displayed, only the first 100 rows are returned from the table. Either the SQL Admin tool (accessible via the WhereScape start menu option), or the Excel query must be used if more detailed data analysis is required.


Query via Excel

Click to query columns in Microsoft Excel.

Tip

When a column list has been displayed in the central pane, it is sorted based on the order field associated with each column. Clicking the column label Col name will sort the columns into alphabetical order. A subsequent click will re-sort based on the order field.


Add Column

Select this option to add new columns. Normally columns can be added via drag and drop.

Add Index

Select this option to add new indexes. Normally indexes are created during the procedure generation phase.

Regenerate Indexes

Select this option to add missing standard indexes. Selecting this option displays a window with options to regenerate missing indexes in the metadata and recreate them or to just regenerate the missing indexes in the metadata.

Relationships

Select this option to manage enhanced relationships. Select this option to perform one of the following:

  • Add Relationship - Displays the Add Relationships dialog.
  • List Relationships - Displays a list of enhanced relationships in the Drop Target Pane for the selected object.
  • Generate Relationships - Generates relationships that have not yet been defined in the metadata

Impact of Change to Table

Select this option to produce a list of objects that will be potentially impacted by a change to the load table structure.

Change Column(s)

Select this option to apply changes to a selected number of columns

Validate for Reserve Words

Select this option to produce a list of table or column names where reserved words have been used; enabled for supported ODBC Drivers.

Validate Against the database

Select this option to compare the metadata for the load table with the physical table resident in the database, and where required the table is altered to match the metadata.

Update Comments

Select this option to refresh the table and column comments on the table, using the table's description and columns' business definition.

Note

You can manage the table and column comments outside the data warehouse environment via the Table and Column Comments menu option.


Version Control

A version of a Load table is a copy of the metadata definition of the table at the time of the versioning. This version information can be used to create a new Load table or can be left as a backup and reference point. Select this option to perform one of the following:

  • New Version - Enables you to create a new version of the selected Load table.
  • Build Application - This enables you to build an application file for the selected Load table.
  • Duplicate Object - Enables you to create a new Load table as a duplicate of the selected table.
  • Revert to Version - This enables you to revert to a previous version of the selected Load table. Displays a list of the available versions of the selected Load table, from which you can select and revert.

    Tip

    The extended property values set in the original Load table is copied to the duplicate Load table. Refer to Extended Properties for details.

Create (ReCreate)

Select this option to create the table in the database based on the definition stored in the metadata. To alter a table select the Validate against database option. Refer to the section on table validation for details.

Truncate

Select this option to truncate the table.

Change Connect/ Schema

This option enables the rapid changing of the Connection information associated with the Load table. This information can be changed in bulk for several Load tables. Refer to Changing Load Connection and Schema for details.

Delete Metadata and Drop Table

Select this to option perform one of the following delete options:

  • Delete metadata and drop object - This option deletes the metadata definition for the table and drops the table object from the database (default). This is a permanent delete and no recovery is provided, use with caution.
  • Delete metadata only - This option deletes the metadata definition for the table.
    A version of the object's metadata is normally auto-created (depending on the settings in Tools > Options > Metadata Versioning).

Load

Select this option to perform an interactive load of the data. The method of loading depends on the type of connection. This menu option is intended for use with small data volumes as in a prototype environment. Large data volumes would normally be scheduled. The Load locks the WhereScape RED screen until completed.

Tip

  • The load option does not drop or create any indexes. Use the Process option if indexes need to be maintained.


Process Table via Scheduler

Select this option to send a request to the Scheduler to immediately process the Load table. This process drops any indexes marked as pre_drop, loads the data, and rebuilds any required indexes. Control is immediately returned to the user and the loading occurs via the Scheduler.

Documentation

Select this option to generate (or read if already generated) the WhereScape RED HTML documentation for the selected object. Select this option to perform one of the following:

Projects

Select this option to perform one of the following:

Note

  • Multiple objects can be selected by double-clicking the Object Group icon in the left pane and then Ctrl + clicking multiple objects in the Drop Target (middle) pane.
  • The above options are unavailable if there aren't any projects in the repository.


Check Out

Select this option to check out the object for editing and prevent any other users from being able to modify, update, or delete any of their associated objects while you are making changes. Refer to Object Check-Outs and Check-Ins for details.

Impact

Select this option to produce several reports and diagrams. Select this option to perform one of the following:

  • Track Back Report
  • Track Forward Report
  • Track Back Diagram
  • Track Forward Diagram
  • Dependent Jobs Report

Code

Select this option to view a procedure associated with a table or to regenerate the table's update procedure. Select this option to perform one of the following:

  • View Load script
  • View Post Load script
  • Regenerate Load script
  • Rebuild Post Load script
  • Regenerate Post Load script

Note

  • Only Load tables with one or more defined procedures have the Code view option.
  • If the Load table is a Script-based load type, either option is displayed in the Code sub-menu:
    • Generate Load Script (if a script is not yet generated)
    • Regenerate <script name> (if a script has already been generated).
      Refer to Script based load for details.

Build

Select this option to build a Scheduler job or an application based on the Load table(s) selected from the middle pane. Refer to Building Scheduler Jobs from Object Groups and Building Applications from Object Groups for details. This option is available from the context menu of Load tables in the middle pane.


  • No labels