Preparing the Data Warehouse
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
This topic discusses the third step in the process of importing custom data into the Commerce Server 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.
Warning
Extend the existing Data Warehouse schema only if it is required. Any changes that you make to the Data Warehouse are irreversible.
For information about how to add data members to an existing class, see Creating a New Data Member.
Metadata Attribute Settings
The following table summarizes the Member metadata attribute settings.
Member attribute |
City |
State |
Fav_Flavor_Code |
|---|---|---|---|
MemberName |
"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.