Extraction, Transformation, and Loading - Data Warehouse Systems: Design and Implementation - page 312

Fig. 8.33 Load of the Customer dimension table
all flows and load the data into the warehouse. A similar data flow task is
used for loading the Supplier dimension table.
Fig. 8.34 Load of the Territories bridge table
The data flow that loads the Territories bridge table is shown in Fig. 8.34 .
This data flow is similar to the conceptual design of Fig. 8.24 .Itstarts
with an OLE DB Source task consisting in an SQL query that joins the