Page History
...
- If required, the EDW 3NF table 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 EDW 3NF table are simple (e.g. one source table) then it is possible to create, load, and update the EDW 3NF table in a couple of steps.
- If you wish 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 EDW 3NF Update Procedure.
| Note |
|---|
It is possible to create and load the table via the Scheduler; by selecting this option from the drop-down list on the Create and Load button:
|
...
- 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 EDW 3NF 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. |
...