Database Reference
In-Depth Information
Find the columns in your tables that relate to each other and drag them from
one table and drop them on the column name that matches in the related
table. For this example, FACTOECDPopulation.CountryID was dropped on
DimCountry.CountryID. Continue this for the remainder of your tables. Often
you'll drag the column from the fact table and drop it on your dimension table.
Step 2c: Clean-up Work
The last thing to do before verifying your model is clean it up. Inevitably,
you will bring in columns you thought you needed but wind up not using,
or columns whose names don't really match or mean anything semantically
valuable to you or your end users. See how in the following figures.
Highlight the columns that you're not using (you can pick columns with little
or no data or that don't seem to be as useful). Right-click in the header of the
column and select Delete. The columns with empty rows near the top right
in this Figure 5-15 are the columns we chose to delete.
FI g u R e 5 -15 Cleaning up columns
Search WWH ::




Custom Search