Chapter 11. Defining the ETL/ELT
Extraction, Transformation, and Loading or Extraction, Loading, and Transformation tools are very common on the market. Implementing a business intelligence and data warehouse project without using one of these tools is highly unlikely as they offer so many benefits. However, just because you implement one of these tools does not mean that there are some areas which are overlooked and not included in the framework. This chapter outlines some of those areas that are often overlooked but are essential within your ETL/ELT framework. The following recipes focus on building the key framework components to be included in each ETL/ELT mapping or process:
- Abstracting your source system
- Separating your extraction from your ...
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.
