Authorities
and privilegesUse the Define Warehouse Source Table notebook to record the description of a new table that you want to include in a specific warehouse source. From this notebook, you can:
Specify a table to include in a warehouse source.
Specify the columns of the table.
Modify the attributes of columns.
Define a warehouse primary key for the table.
Define warehouse foreign keys for the table.
The Data Warehouse Center does not physically create warehouse primary or warehouse foreign keys in the tables that it defines as source tables. Source tables may or may not have had keys created for them prior to the tables being defined as warehouse source tables. You can define warehouse primary keys and warehouse foreign keys to document logical or physical relationships in the data.
To define a warehouse source table:
In the Table schema field, specify a schema for the table that you are creating.
In the Table name field, type a fully qualified name for the table that you are creating. The name can contain up to 128 characters and be an ordinary or delimited identifier.
Table names can be case sensitive, or have other restrictions, for some warehouse source types. See the documentation for your warehouse source type for information about naming conventions.
Optional: In the Table space field, specify the table space in which to create the table.
Optional: In the Index table space field, specify the table space in which to create any indexes on the table.
Optional: In the Description field, type a short description of the table.
Optional: In the Business name field, type a name for the table that end users will easily recognize.
On the Columns page, right-click in the whitespace of the table and select Add, or right-click a row and click Insert. If you click Add, a blank row is added below all other rows. If you click Insert, a blank row is inserted above the selected row.
Type the name of the column in the Column name field.
Column names can be case sensitive for some data source types. The Data Warehouse Center can store column names that are up to 128 characters in length. See the documentation for your data source type for information about naming conventions and restrictions.
In the Data type field, specify a data type for the column.
If you specify a data type that requires a byte count, specify the length in the Length field.
For example, you must specify a length for CHAR data types.
If you specify the DECIMAL data type, specify the precision in the Precision field.
Precision refers to the total number of digits, which can range from 1 to 131.
If you specify the DECIMAL data type, specify the scale in the Scale field.
Scale refers to the number of digits to the right of the decimal point, which can range from 0 to the precision of the number.
To ensure that the code page is translated properly, select the Is Text check box if the CHAR or VARCHAR field contains text.
Select the Nullable box if null (nonexistent or unknown) values are allowed in the table.
Optional: Select Replication before to capture the before-image of the column if the source is a replication source.
Optional: Select Replication after if the column is defined for change capture.
Optional: In the Description field, type a description for the column.
Optional: Click Move up to move the selected column up one position in the list or click Move down to move the selected column down one position in the list.
Optional: To remove a column from the table, right-click the row containing the column and select Remove.
Click OK to save your changes and close the notebook.
Related information