2nd February 06:02
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?