Provide the name for the facts object and select the schema (see Figure 3-28).
Figure 3-28 Facts object’s name
Chapter 3. Building a cube model in DB2 97
Click Next and select the table that is required for the facts object (see
Figure3-29).
Figure 3-29 Select the Facts table
.
Note: If more than one table is needed to build the facts object, then you will
be prompted to specify the join. In our illustrative star schema, there is only
one table for the facts object.
98DB2 Cube Views: A Primer
Select Next to select ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.