Otherwise, you add along the primary dimension, producing an new array of reduced dimension. For example.

The star schemas require the generation and proper use of primary or foreign keys for the fact and dimension tables.

A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.