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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.