Authorities
and privilegesUse the Define Warehouse Source View notebook to record the description of a new view that you want to include in a specific warehouse source. From this notebook, you can:
Define a view to include in a warehouse source.
Specify the columns of the view.
Modify the attributes of columns.
Define a warehouse primary key for the view.
Define warehouse foreign keys for the view.
To define a warehouse source view:
In the View schema box, specify a schema for the view that you are creating.
In the View name field, type a fully qualified name for the view that you are creating. The name can contain up to 128 characters and be an ordinary or delimited identifier.
View 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 Description field, type a short description of the view.
Optional: In the Business name field, type a name for the view 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. 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.
Select the Is Text check box if the CHAR or VARCHAR field contains text. This ensures that the code page is translated properly.
Select the Allow NULL check box if null (nonexistent or unknown) values are allowed in the view.
Optional: Select the Replication before check box to capture the before image of the column if the source is a replication source.
Optional: Select the Replication after check box if the column has been defined for change capture.
Optional: In the Description field, type a description for the column.
Optional: To remove a column from the view, right-click the row containing the column and select Remove.
Click OK to save your changes and close the notebook.
Related information