ETL Process for the Transaction Data Import DTS Task
The Transaction Data Import DTS task imports site transaction data, such as purchase orders and requisition numbers, into the Data Warehouse. The Transaction Data Import DTS task should be run before creating reports that synchronize transaction data.
Caution
- When running the Transaction Import DTS task on a Data Warehouse that contains data for multiple Web sites, ensure that classes extended by more than one Web site have uniquely named members if their data types are not the same. If a new member is added to a class in multiple Web sites and the data types of the new members are not the same, a failure might occur or data might be incorrectly converted when the Transaction Import DTS task is run.
The following tables list the columns extracted from the source tables in the Site_commerce database, the transformation made, and the tables to which the data is saved in the Data Warehouse.
Source columns from the OrderGroupAddresses table of the Site_commerce database | Transformation | Target columns from the OrderGroupAddresses table in the Data Warehouse |
---|---|---|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
Source columns from the OrderFormHeader table of the Site_commerce database | Transformation | Target columns from the OrderFormHeader table in the Data Warehouse |
---|---|---|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Generated
If the column exists in the OrderFormHeader table of the Site_commerce database, the value is copied to the CurrencyCode table in the Data Warehouse, and then the ID for the code is placed in the OrderFormHeader table. |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Generated
A normalized date value including the hour is written into the date table and an ID is loaded here. |
|
|
Copy Column |
|
|
Copy Column |
|
Source columns from the OrderFormLineItems table of the Site_commerce database | Transformation | Target columns from the OrderFormLineItems table in the Data Warehouse |
---|---|---|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Generated
Provider-generated six-byte ID that links this record with the OrderformHeader table. |
|
|
Generated
Provider-generated 6-byte ID that links this record with the OrderGroupAddresses table. |
|
|
Generated
Provider-generated 6-byte ID. |
|
|
Copy Column |
|
|
Copy Column |
|
Source columns from the OrderGroup table of the Site_commerce database | Transformation | Target columns from the OrderGroup table in the Data Warehouse |
---|---|---|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Copy Column |
|
|
Concatenation |
|
|
Copy Column |
|
|
Copy Column |
|
See Also
Running the Transaction Data Import DTS Task
Scripting the Transaction Data Import DTS Task
Workflow for Running DTS Tasks
Copyright © 2005 Microsoft Corporation.
All rights reserved.