Merging new system data into existing data mart

[Bisquite]

We currently have a datamart in SQL Server which pulls information daily from hundreds of standalone booking/billing systems round the world. This datamart is used for reporting.

We have just developed a new system to replace the standalone ones. It is our intention to gradually roll out the new system over the next 12 months or so. During this period we need to keep pulling info from the old systems whilst also pulling from the new system into the same datamart.

Has anyone found any good resources for this kind of project?

 

[johnherman]

You need to map and/or transform your data. This is a key Data Warehouse concept. You may need to redesign your target tables to include columns in the new system and not in the old system. You may need to transform data domains from the old system to the new system or to a third set of values. These are typical data warehouse activities.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright