O'Reilly logo

Connecting the Data by Angelo R. Bobak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 6

Designing the Interim Schema

images

Having generated the necessary physical models and data dictionaries in Chapter 5, we now apply schema integration techniques to merge the models of the MS Access database and the model for the Excel spreadsheets into one model. This will be our first interim model which will be merged with the SQL Server physical model so as to produce the second interim schema which will be the basis for the ODS. We will follow the process introduced in Chapter 3 and generate the various data dictionaries that will be used to create the ETL logic for resolving the data conflicts.

We will then merge the interim schema ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required