Preserving Data Using Outer Joins

For the next two properties, consider the following simple example data.

Store Table (lookup)

Store ID	Store Name
1	East
2	Central
3	South
6	North

Fact Table

Store ID	Year	Dollar Sales
1	2002	1000
2	2002	2000
3	2002	5000
1	2003	4000
2	2003	6000
3	2003	7000
4	2003	3000
5	2003	1500

The Fact table has data for Store IDs 4 and 5, but the Store table does not have any entry for these two stores. On the other hand, notice that the North Store does not have any entries in the Fact table. This data is used to show examples of how the next two properties work.