Populating a Dimension Table
Dimension tables are part of a star schema and contain detailed information for the columns in the fact table. Dimension tables have attributes and a single part primary key that joins the dimension table to the fact table. The single part primary key allows you to quickly browse a single dimension table. Browsing a dimension table can help determine the best way to query the fact table.
The following procedure describes how to use Spectrumâ„¢ Technology Platform to perform the initial population of a dimension table in your data warehouse.
Note: Before beginning this procedure, you must have defined connections to external
resources you want to use as the source for the dimension table if you are using a
database, file server, or web service as the source for the data. You must also
define a connection to the data warehouse in which you want to create a dimension
table. If you have not defined the necessary connections, see Introduction to Data Sources.