Databases Reference
In-Depth Information
Follow these steps to load a fact table:
1.
Go to the
Edit Script
window by pressing
Ctrl
+
E
or by selecting
File
|
Edit Script...
from the menu bar.
2.
In the
Edit Script
window, we will initially have 10 lines of code, all starting
with the word
SET
. Those are the initialization variables for some common
formatting options. We will leave them as they are for now.
3.
At the bottom of the
script editor
, we will see a set of tabs containing specific
functions regarding script generation. Make sure the
Data
tab is active and
mark the
Relative Paths
checkbox, as shown in the following screenshot:
4.
Position the cursor a few lines below the initialization statements and click on
the
Table Files…
button to bring up the
Open Local Files
wizard. Browse to
the
Data Files\QVDs
folder we created in the previous section and select the
Flight Data.qvd
file, as shown in the following screenshot. Click on
Open
.