Page History
...
- If required, the Data Store Object can be changed to be a history table by choosing History from the table type drop-down list on the right side of the dialog. History tables are like slowly changing dimensions in dimensional data warehouses. Refer to Building a Dimension for details. Change the storage options if desired.
- If prototyping and the Data Store Object is simple (e.g. one source table) then it is possible to create, load and update the Data Store Object in a couple of steps.
- If you want to do this, select the (Build Procedure...) option from the Update Procedure drop-down, and answer Create and Load to the next question.
...
If Create or Create and Load is selected and a new procedure creation is chosen, proceed directly to the Generating the Data Store Update Procedure.
If you have additional columns to add or columns to delete then select Close and proceed as follows below.
...
- It is possible to delete any unwanted columns by highlighting a column name or a group of names and clicking Delete.
- The name of a column can also be changed by right-clicking the column and choosing Properties to edit its properties.
- Any new name must conform to the database naming standards. Good practice is to use alphanumerics and the underscore character.
Refer to Data Store Column Properties for more details.
| Tip |
|---|
When prototyping and in the initial stages of an analysis area build, it is best not to remove columns, nor to change their names to any great extent. This type of activity is best left, and done after end users have used the data and provided feedback. |
...
- It is a simple matter to select columns from other load and/or stage tables and drag these columns into the middle pane.
- The source table column in the middle pane shows where each column was dragged from.
- The column description could be acquired from three different tables. Best practice is to rename at least two of the columns, perhaps also adding context to the column name. For example, description could become group_description, and so forth.
- Several WhereScape RED ancillary columns do not have a source table.
These columns have been added by WhereScape RED , and are and are added depending on earlier choices.
...
- This is done by right-clicking on the Data Store Object in the left pane and selecting Create (ReCreate) from the pop-up menu.
- The Results pane displays the results of the creation. A message confirms that the Data Store Object was created. A copy of the actual database create statement and if defined, the results of any index create statements is listed. For the initial create, no indexes will be defined.
- If the table was not created, then ascertain and fix the problem. A common problem is a 'Duplicate column' where a column has the same name in two of the source tables. The best way to find such a column is to double-click the list heading Column Name, which sorts the column names into alphabetical order.
- Another double-click on the heading sorts the columns back into their create order.
The next section covers Generating the Data Store Update Procedure.