Method 1: Transform, Then Load
Let me start by simply mapping out the optimally efficient transform, then load implementation options (shown in Figure 6-4).
Figure 6-4. “Transform Then Load” Implementation Options
Yes, there are implementation options other than those presented in Figure 6-4. But these methods represent the optimally efficient techniques available, period. Let's examine each of these five scenarios in more detail.
Scenario 1
If you only need simple data transformations and you're using Oracle 8i, then your best and most obvious choice is to simply use SQL Loader. Of course, you'll have to write the correct control file to implement ...
Get Oracle® DBA Guide to Data Warehousing and Star Schemas 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.
