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 7

Preparing the ETL Specifications

images

Having generated the necessary physical models and data dictionaries in Chapter 5 and having generated our interim schema in Chapter 6, we are ready to create the ETL specifications for our processes that will load the data, resolve any data conflicts and finally merge the data into the ODS database.

Our ETL specifications will be based on three types of process diagrams and one type of report that describes the ETL logic required to resolve the conflicts we discovered in Chapter 6. Specifically we will create:

• A data flow diagram that depicts the flow of information and identifies the tasks that ...

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