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.
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 ...