Database Reference
In-Depth Information
Fig. 8.18
Overall view of the conceptual ETL process for the Northwind data
warehouse
Fig. 8.19
Load of the
Category
dimension table
thus, we need three lookup tasks, as shown in the annotations in Fig.
8.22
.
The three lookups are as follows:
The first lookup process records where
State
and
Country
correspond,
respectively, to
StateName
and
CountryName
. An example is state
Loire
and country
France
.
Search WWH ::
Custom Search