Creating an SQL generation work product

Procedure

We are now going to create an SQL generation work product for the physical model.

After following the procedure represented in Figure 12, we will then look at the dialog box for an SQL work product (Figure 13).

Figure 12. Creating a SQL generation work product for the "MPD_Library" package

Steps:

1. Select the "MPD_Library" package in the explorer.

2. Click on the icon. The "SQL generation work product" window (shown in Figure 13) then appears.

Defining an SQL generation work product

The SQL generation work product dialog box (shown in Figure 13) is used to indicate the generation directory for SQL scripts.

Figure 13. The "SQL generation work product" dialog box