Database Reference
In-Depth Information
4.
Type in the annotations as listed here (Figure
7-22
):
•
Clear tables before refilling the data warehouse
•
Fill dimension tables before filling the fact tables
•
once the dimension tables are full, fill the fact tables
•
Perform final tasks like replacing the foreign key constraints
5.
Move the annotation to the upper-left corner of each sequence container, as
indicated in Figure
7-22
.
Your ssis package should now look similar to that shown in Figure
7-22
.
Figure 7-22.
Outlining the sequence containers and adding annotations