Databases Reference
In-Depth Information
subset of these tables at any given time, and the Diagram Organizer is a
handy way to create several diagrams that include just such subsets of relev-
ant tables. Note that operations done on the tables within this diagram are re-
flected real-time in the entire DSV. By default you get one diagram that is
called All Tables.
Figure 4-5
Figure 4-5
shows part of the default diagram All Tables that is created at the
completion of the DSV wizard. The lower left pane is called Tables and is
used to show the tree view of all the tables of the DSV along with their rela-
tionship with other tables.
Figure 4-6
shows the Tables pane with detailed in-
formation of the DimCurrency table; you can see the primary key of the
DimCurrency table and the CurrencyKey, which is distinguished by a key
icon. In addition, there is a folder that indicates all the relationships between
the DimCurrency table and other tables in the DSV. If you expand the Rela-
tionships folder (as shown in
Figure 4-6
)
you will see that the DimCurrency
table joins to the FactInternetSales and FactResellerSales through the Cur-
rencyKey — where the join is specified within parentheses.
Search WWH ::
Custom Search