Visite Webhosting Latino, el site sobre alojamiento web.
Impact of Catalog changes on the Data Warehouse? - Mombu the Microsoft Forum
Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Impact of Catalog changes on the Data Warehouse?
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 2nd February 06:02
External User
Posts: 1
Default Impact of Catalog changes on the Data Warehouse?

CS2002 (SP2 + Feature Pack 1)

I am working with a client that is planning on migrating 6 base
catalogs into one. There will continue to be some virtual catalogs off
of the single base catalog. The concerns are in what happens to the
data warehouse and reports. The site has been collecting data (orders,
products, web logs) for nearly a year and they don't want to lose their
data. All of the products will continue to reside in the new base
catalog and the previous base catalogs will simply be the top level
category in the new base catalog.


What happens to the current data warehouse? Can I simply rebuild the
entire data warehouse?

What happens to the reports? Which stock reports are affected?

What should I be concerned with in the migration of data?

What tables do I need to manually write SQL scripts for in order to
update from the previous to the new catalog?

What steps should I follow?

  Reply With Quote

  sponsored links


Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -