How to Map a Profile Property to a Storage Location
Profile properties use data members to map data that users enter on the Web site to the appropriate storage location. For example, when a user types a first name into the First Name property of the User Object profile definition, Commerce Server stores the name in the database column that the data member for the First Name property specifies.
You can map profile properties from a single profile definition to data members from different types of data sources. Make sure that there is a primary key data member on the data object that you want to map.
To map a profile property to a storage location
Expand Commerce Server Manager, expand Global Resources, expand Profiles, expand Profile Catalog, expand Profile Definitions, and then click the profile definition that contains the property you want to map to a storage location.
In the Commerce Server Manager, in the right pane, in the Properties list, expand the property group that contains the property that you want to map, and then select the property.
In the Commerce Server Manager, in the right pane, in the Advanced Attributes section, in the Map to Data box, click the ellipsisbutton [...] to open the Data Source Picker dialog box.
In the Data Source Picker dialog box, expand the data source that contains the data object that contains the data member with which you want to map the property.
Expand the data object that contains the data member with which you want to map the property, select the data member, and then click OK.
In the Commerce Server Manager, in the right pane, in the Advanced Attributes section, select Exported to specify that this property will be exported to the Commerce Server Data Warehouse. You can export only mapped properties.
You cannot export properties that are multivalued and of the type Boolean or properties of the type binary, long,string, or password.
Click Apply.
The profile property data will be stored in the designated data member, and will be imported into the Data Warehouse.
If you want to specify the location into which the data will be imported in the Data Warehouse, you will have to add the DWClassName custom attribute to the profile definition, and the DWMemberName custom attribute to the profile property.