Manage Table Column Changes

Table columns are created in Data Mart based on the field attributes you add to Data Mart. When you modify field attribute type or size, the columns in Data Mart are modified accordingly.

When you edit and then save a model, column types are changed from CHAR to VARCHAR, or VARCHAR to CHAR as appropriate. If the model is not yet built, the Data Mart table is automatically modified. If the model is already built, and the field attribute type is changed, a message appears when you save the model informing you that you must modify the table manually by generating a script.

To modify the table manually:

1. In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
   You see the Data Mart workspace.

2. Select a model and right-click.

3. Select Generate script to modify column types.
   If there were column type changes in the model, the script is generated. The new script appears in the Scripts to Modify Column Types window as shown in the following figure.
   
   

   Open

   

   If there were no changes, you see a message stating 'No changes in the Column Type'.

4. Follow the directions that appear in the Scripts to Modify Column Types window.
   You can validate all models in the Mart at the Mart level. This procedure generates a script based on any column type changes for all models.

To validate changes at the Mart level:

1. In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
   You see the Data Mart workspace.

2. Click the Administration link and select Column Type Diagnostics.
   You see the Scripts to Modify Column Types window.

3. Follow the directions that appear in the Scripts to Modify Column Types window.