Preparing the Data Warehouse
This topic discusses the third step in the process of importing custom data into the Commerce Server 2000 Data Warehouse. For the previous two steps, see Planning a Custom Import Task. In the second step, it was determined that the RegisteredUser class must be extended to encompass line-of-business (LOB) data. Specifically, three new data members are needed: City, State, and Fav_Flavor_Code.
***.gif "Ee810235.caution(en-US,CS.10).gif")
*Caution
- Extend the existing Data Warehouse schema only if absolutely necessary. Any changes made to the Data Warehouse are irreversible.
The process of adding data members to an existing class is detailed in Creating a New Class Data Member. The MemDef meta-data attribute settings are summarized in the following table.
| MemDef Attribute | City | State | Fav_Flavor_Code |
| MemDefName | "City" | "State" | "Fav_Flavor_Code" |
| TypeName | "String" | "String" | "ULONG" |
| IsPrimaryKey | 0 | 0 | 0 |
| IsExported | 0 | 0 | 0 |
| IsActive | 0 | 0 | 0 |
| IsPersistent | 1 | 1 | 1 |
| GenerateColumnDef | 1 | 1 | 1 |
| Description | "User Loc:City" | "User Loc:State" | "Ice Cream Flavor" |
The new data members have now been added to the RegisteredUser class. For the next step, see Staging the Data.