Authorities
and privilegesUse the Define Warehouse Target Table notebook to describe a new table that you want to include in a specific warehouse target. From this notebook, you can:
Specify a table to include in a warehouse target.
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.
To add a new column to a target table that has been created in the database (promoted to test mode) without demoting the step, add the column to the table and then invoke the Alter command by right-clicking the table and selecting Alter.
To define a warehouse target 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. If the table is to be used for replication, the name can contain up to 18 characters.
Table names can be case sensitive, or have other restrictions, for some warehouse target types. See the documentation for your warehouse target 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.
Optional: Select Data Warehouse Center created table to have the Data Warehouse Center create the table when you promote the step to test status. This box is checked by default.
Optional: Select Transient data to specify that the source data is temporary and will be deleted immediately after the target that receives the data is populated.
Optional: Select Grant to public to give access to this table to all users that have access to this database. The grant will take effect after the process is promoted to test status.
In the Number of editions field, specify the number of times that you want the data in this table to be replaced when the process is run. Leave the default of 0 if you want the Data Warehouse Center to append data each time the process runs.
Optional: Select Part of an OLAP schema to indicate that the table is to be part of an OLAP schema, then indicate whether the table is to be a dimension table or a fact table.
On the Columns page, right-click in the white space 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. See the documentation for your data source type for information about naming conventions.
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.
Check 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: To remove a column from the table, right-click the row containing the column and select Remove.
Optional: View or edit the SQL that the Data Warehouse Center generated for the columns that you specified.
Click OK to save your changes and close the notebook.
Related information