|
Home > Archive > Commerce Server General > February 2004 > Data Warehouse: Transactions Incremental Import
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Data Warehouse: Transactions Incremental Import
|
|
| James Thurston 2004-02-07, 9:36 am |
| Hi,
I've been using Commerce Server 2002 with Data Warehouse for some
months, and have just noticed something puzzling. I have a
full load of transaction data from mid-December in the data warehouse
and have been running incremental imports every night since that full
import. However it looks as though CS only imports new rows during
the Transaction DTS Import; any existing records are left alone in DW
even if the data has changed considerably.
Can anyone verify whether incremental updates ignore the existing data
in the DW database? If this is the case, does anyone have any
thoughts on how to get around this when we have orders whose status'
get updated regularly, and we cannot select which records get exported
to the data warehouse in the first place?
Thanks
Jim
| |
| James Thurston 2004-02-07, 9:37 am |
| OK, I've figured it out...for reference, you need to make sure the
d_DateLastChanged field is always updated if you use your own queries
to update these tables. Then the changes will propagate to the DW.
Jim
|
|
|
|
|