How To DTS Import Transaction Database Custom Data to Data Warehouse (324149)


The information in this article applies to:

  • Microsoft Commerce Server 2002
This article was previously published under Q324149

SUMMARY

A Transaction DTS task does not export to the Datawarehouse database any new fields or new columns that you add to OrderGroup, OrderGroupAddress, OrderFormHeader, or OrderFormLineItems.

MORE INFORMATION

There are four Transaction tables where the Transaction DTS locates data. These are OrderGroup, OrderGroupAddress, OrderFormHeader, and OrderFormLineItems.

If you add fields or columns to these tables, Transaction DTS may not recognize them. To export the data in those additional custom columns to the DataWarehouse database, do the following:
  1. For a new field in any of the four Transaction tables, add an entry in the TransDimension Table (located in the Commerce transaction database) that has the RequiredDim column set to 1.

    For example, if you add a custom column named TaxPercentage to the OrderformHeader table, an entry should be added to the Transdimension table as in the following example:
    DimensionName  FieldName      CategoryName    KeyField RequiredDim
TaxPercentage  TaxPercentage  OrderFormHeader  0        1

  2. After this change, you can use the Transaction DTS to import data in the custom column TaxPercentage into the Data Warehouse.
Modification Type:MinorLast Reviewed:7/1/2004
Keywords:kbfix kbhowto kbnofix kbpending KB324149
©2004 Microsoft Corporation. All rights reserved.