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:
| ||||||||||||||||||||||||||
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 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. | ||||||||||||||||||||||||||
Gather Statistics | Select this option to gather statistics on a table. This action enables the underlying database to optimize each query based on the statistics collected about the data that is being accessed. Select this option to perform one of the following:
Tip Oracle has the statistics option in the Options window to save a generic statistics statement for analyze, quick analyze, stats and quick stats. If there is no statistics statement saved then a default statistics statement is used. The statistics process from the object context menu for tables is described below:
Oracle Gather Statistics context menu example:
| ||||||||||||||||||||||||||
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 simply be left as a backup and reference point. Select this option to perform one of the following:
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 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 a number of 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:
A version of the object's metadata is normally auto created (depends 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
| ||||||||||||||||||||||||||
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, load the data and rebuild 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
| ||||||||||||||||||||||||||
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 a number of reports and diagrams. Select this option to perform one of the following:
| ||||||||||||||||||||||||||
Code | Select this option to view a procedure associated to a table or to regenerate the table's update procedure. Select this option to perform one of the following:
Note
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 listed in the middle pane. |