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 ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
