Abstracting your source system
For a business intelligence and data warehouse project, there are normally numerous source systems. All these source systems will have their individual data models and standards. Whether you are connecting to packaged or custom applications, at some time during the lifecycle of the project, these systems will undergo application upgrades. It is important to be able to abstract the business intelligence and data warehouse project from these upgrades so as to minimize the impact, and create a single point of failure.
Getting ready
Identify all your source tables from the Developing the data lineage recipe in Chapter 8, Analyzing the Sources. Obtain usernames and passwords for all the source systems with the necessary ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology 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.
