Managing a data mart
You might need to drop or re-create a data mart, for example, if the schema of the underlying tables is changed, or if you create a new data mart and need to remove an old data mart.
When you modify the schema for the tables on the database server,
you must drop and re-create the data mart. Examples of schema modification
operations include:
- Renaming tables
- Renaming columns
- Altering tables to add or drop columns
- Changing the datatype of the columns
- Adding or dropping constraints
Drop the original data mart and deploy and load the new data mart.Drop the original data mart and load the new data mart. The new and old data marts must have the same data mart definition, but different names. Make sure you save the data mart definition file with a different file name before you drop the original data mart.