Databases Reference
In-Depth Information
To continue, make sure you've defined the settings as depicted
in the screenshot shown at the beginning of this section.
After we've set these configurations, we are done with this window. Let's click on
Next
to continue with the following step in
File Wizard
.
The transformation step
The second step in the
File Wizard
is the
Transform
process. Since, for now, we
are not going to make any transformation to our file, we are going to skip this step.
However, it is important that you know how and when this can be useful for you.
Chapter 9
,
Basic Data Transformation
, covers this topic more in depth.
Let's just say, for now, that the transformation step is used when loading files that
are not in a format consistent with a traditional table (that is, pure and clean rows
and columns). The
Transform
dialog is shown here:
As you can see, there is a warning about using this feature: it requires a large amount
of RAM. If your source file is large, you might not find this
Transform
wizard useful,
and other techniques will need to be employed to process the source data.
Click on
Next
once more to skip the transformation step, and move to the third step
in the
File Wizard
.