Share via


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.

See Also

Other Resources

Importing Custom Data into the Data Warehouse