View Source

Typical Storage screen for a Greenplum table
WhereScape 9.0.2.4 > Table Storage Screen - Greenplum > Table Storage Screen Greenplum.png

Location

Fields

Description

Target Location

The target location that defines the path of the table. Select (local) for a local table or select the target schema if you are locating tables in different schemas.

The Force Target Usage setting in the Tools > Options > Storage > Target Usage removes the local target option from the drop-down list. Refer to Target Usage for details.

To add another database/schema to the list see more details on Connections - Database or Connections - ODBC.
To set default target locations for tables, refer to Settings > Storage > Target Location.

When upgrading from a RED version previous to 6.8.2.0 and moving existing objects to a target location, all procedures that reference those objects need to be rebuilt. Any FROM clauses will also need to be manually regenerated in order for the table references to be updated to the new [TABLEOWNER] form.

If the database type does not support moving tables, such as Oracle, Greenplum, Netezza, Teradata and PDW, all affected tables need to be manually recreated after any storage changes. Please note that changing the Storage for Dimension and Fact tables need to be handled very carefully, as artificial key relationships between Dimension and Fact could become out of sync. Recreating Fact tables and large Dimension tables might take a considerable amount of time.

Database Type

The database type for a connection that is used for target Datawarehouse tables.

Database

The database where the table is located. Leave blank to use the default for the connection or local environment.

Schema

The schema where the table is located.

Owner

Owner to which the object is altered.

Create DDL Template

Optional. Specify the template to use when creating a new DDL procedure script. This option is only visible if a DDL template is available for this database type. Default value is None.

Storage

Fields	Description
Tablespace	Default tablespace of the table that determines the storage location it is created in. Select (Default) to use the default.
Distribution Method	Select the Data Distribution Method. Options are Hash and Random (Round-Robin)

Enable Fill Factor

Setting this will enable setting of the Fill Factor.

Fields	Description
Fill Factor	Percentage [10-100] between 10 and 100. 100 (complete packing) is the default. When a small fill factor is specified, INSERT operations pack table pages only to the indicated percentage. The remaining space on each page is reserved for updating rows on that page.

Append Only

When set, will create the table as append-only. If this field is not set, the table will be created as a heap-storage table.

Fields	Description
Orientation	Columns selected to make up the Distribution Key.
Compression Type	Table-level compression is applied to an entire table.
Compression level	Table-level compression is applied to an entire table.

Other

Fields

Description

Optional CREATE Clause

Database-specific-and-compliant DDL to append to the generated CREATE TABLE statement.

To set default create clause values for all new objects, go to the Tools > Options > Storage menu - Default Optional CREATE Clause.