We can create our Store dimension in a similar manner using the wizard. We will not go through it in much detail as it is very similar to how we created the Product dimension. The only difference is the type of information we're going to have in our Store dimension. This dimension provides the location information for our data warehouse, and so it will contain address information.
The creation of this dimension will be left as an exercise for the reader using the following details about the dimension.
ID (Dimension/Level): Leave default for type and size (Surrogate ID)
Store_Number (Level, STORE only): VARCHAR2 length 10 (Business ID)
Name (Dimension/Level): VARCHAR2 length 50 (Business ID)
Description (Level, COUNTRY and REGION only): VARCHAR2 length 200
Address1 (Level, STORE only): VARCHAR2 length 60
Address2 (Level, STORE only): VARCHAR2 length 60
City (Level, STORE only): VARCHAR2 length 50
State (Level...