Database Reference
In-Depth Information
Figure 3-9.
he current pubs database
Deciding Which Tables to Include
Although the titles table is the center of the diagram, the sales table provides us with information about
the company sales. Therefore, this table is the focus of our reporting efforts. As you examine this diagram,
notice that the other tables seem to support the sales information. Each table at some point was considered
important, but this is not the same as being important to our BI solution. It is a best practice not to include
everything from the OlTP environment into the data warehouse. Instead, each table should be reviewed to
determine its relevance to the current BI solution.
