O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

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

EXTERNAL DATA

Some data warehouses may already have access to external data. By this we do not mean external data that is imported into the warehouse during the extraction, transformation, and load process. What we mean is that there are links to external data that our users can, seamlessly, reach out to. Over time, this will become more and more popular until the point is reached where access to external data becomes a fundamental requirement.

There are some industries, especially pharmaceuticals, where there are hundreds of research and epidemiological databases that companies can subscribe to. Now, some of these databases are simply huge and it would be highly inappropriate to attempt to copy them into our own data warehouse. Somehow, we have ...

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