Use this page to specify information about the target table.
Data
Warehouse Center created table
To specify a schema with a name that is different than this user ID, use one of these methods:
Click on the down arrow to display a list of existing schemas and select one.
Type the name of the schema that you want. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, you can name a new one. This name:
Can contain up to 128 characters.
Cannot be one of the following reserved schema names: SYSCAT, SYSFUN, SYSIBM, or SYSSTAT.
Can be an ordinary or delimited identifier.
You do not need to specify a table space. If you created a table space from your user ID, the table will be created in that table space. If no table space is found, the table will be created in the default table space, USERSPACE1.
You must specify a REGULAR DMS table space other than the default table space if you plan to specify a specific index table space or long data table space.
This field is available only if you specified a table space other than the default in the Table space box. If you do not specify an index table space, the indexes will be created in the same table space as the table.
Data Warehouse Center-created table
Clear this check box if you do not want the Data Warehouse Center to create or drop the table. For example, clear this check box for a step that updates a target table that was created using replication or a modeling tool.
If this check box is not selected, the Data Warehouse Center will not create a table when you promote the step to test status. However, the table must already exist, so the Data Warehouse Center can compare the SQL that is generated for the step with the actual table. If you select this option, ensure that the table does not use delimited identifiers. The Data Warehouse Center does not support delimited identifiers.
You can change this field if the step status is development or test.
Select to specify that the target data is temporary and will be deleted immediately after any step which uses the data as a source has run. If you do not define a receiving step (for the step marked Transient), the step cannot be run and will not be displayed in the Work in Progress window.
If you want to test this step without defining a receiving step, define it as you normally would and do not select this check box. Process the step and delete all data populated while the step mode is test. Then select the check box before changing the mode to production.
You can change this check box if the step mode is development or test.
This check box is not available if you do not have a target linked to the step.
The grant will take effect after the step is promoted to test status.
If you change this field to a number greater than zero, a column called RUN_ID is added to the table. If you change this field from a number greater than zero to zero, the RUN_ID column is removed from the table.
You can change the number of editions freely while in Development mode. In Test mode, you cannot change from a number greater than zero to zero. In Production mode, you cannot change this field.
Use this page to add, change, or remove column definitions for a table.
You can select a new column to change any field, remove the new column from the table, or reorder the new column among the other new columns.
Specify the data type of the column that you are adding. To specify the data type, click the down arrow to display a list of data types and select one.
The data type can be:
CHARACTER
NUMERIC
DECIMAL
INTEGER
SMALLINT
FLOAT
DOUBLE
REAL
DATE
TIME
TIMESTAMP
VARCHAR
LONG VARCHAR
GRAPHIC
VARGRAPHIC
LONG VARGRAPHIC
BLOB
CLOB
DBCLOB
Specify the length (byte count) of the columns based on the specified data type:
CHARACTER: The length of the fixed-length character string, which can range from 1 to 254. The default is 10.
VARCHAR: The maximum length of the varying-length character string, which can range from 1 to 4000. The default is 10.
GRAPHIC: The length of the fixed-length graphic string, which can range from 1 to 127. The default is 0.
VARGRAPHIC: The maximum length of the varying-length graphic string, which can range from 1 to 2000. The default is 0.
BLOB: The maximum length of the BLOB string, which can range from 1 to 2 147 483 647. The default is 0.
CLOB: The maximum length of the CLOB string, which can range from 1 to 2 147 483 647. The default is 0.
DBCLOB: The maximum length of the DBCLOB string, which can range from 1 to 1 073 741 823 double-byte characters. The default is 0.
Use this field to specify the precision of a DECIMAL or NUMERIC number. The precision is the total number of digits, which can range from 1 to 31. If you do not specify the precision, a default value of 5 is used.
This field is available only if you specified DECIMAL or NUMERIC in the Data type field.
Use this field to specify the scale of a DECIMAL or NUMERIC number. The scale is the number of digits to the right of the decimal point, which can range from 0 to the precision of the number. If you do not specify the scale, a default value of 0 is used.
This field is available only if you specified DECIMAL or NUMERIC in the Data type field.
Select to allow the column to contain null values. The default value for the column is either the null value or the value specified in the Default field.
If the column will be a warehouse primary key column, it cannot be nullable.
Select if the column will contain text. Enabled for the following data types:
CHARACTER
VARCHAR
LONG VARCHAR
GRAPHIC
VARGRAPHIC
LONG VARGRAPHIC
Type a description for the column. The description can have a maximum
length of 200 characters.
This page is displayed for DB2 tables only. Use this page to:
Manually define the warehouse primary key for a target table to the Data Warehouse Center.
View the warehouse primary key definition that was imported from DB2.
You can define up to 16 columns as warehouse primary key columns. The sum of their length attributes must not exceed 255 bytes.
You cannot define columns of data type LOB, LONG VARCHAR, or LONG VARGRAPHIC to be warehouse primary key columns.
Use this list to view the warehouse primary key columns or to select a column or columns to remove from the list with the < push button.
To add a column to this list, select a column from the Available columns list, and then click >.
This page is displayed for DB2 tables only. Use this page to:
Manually define the warehouse foreign keys for a target table to the Data Warehouse Center.
View warehouse foreign key definitions that were imported from DB2.
Before you begin, you must know the names of the warehouse primary keys and tables to which the warehouse foreign keys correspond. Warehouse foreign keys are used in a data warehouse to document the relationships between facts and dimensions. These relationships should be used in the warehouse for population and for usage, either by query tools or OLAP cubes.