Databases Reference
In-Depth Information
tABle 13.11
Manufacturing Dimensions with Simple Instance Keys
factory Worker
Name
Certification
Safety Rating
Row_First_Date
Row_Last_Date
Instance Key
Fred
Cratsman
AA+
April 14, 2007
Dec. 31, 9999
942
raw material
Name
Supplier
Quality
Row_First_Date
Row_Last_Date
Instance Key
Iron Ore
Hess Ironworks
95%
March 14, 2006
May 11, 2010
385
Iron Ore
Hess Ironworks
96%
May 12, 2010
Dec. 31, 9999
482
location
Name
Geography
Hierarchy
Row_First_Date
Row_Last_Date
Instance Key
Atlanta Iron 35
Atlanta, GA
Metals
Feb. 6, 1998
Dec. 31, 9999
234
formula
Name
Fail Rate
Skill Set
Row_First_Date
Row_Last_Date
Instance Key
RWU987
4%
Iron Cratsman
Jan. 20, 2005
Nov. 24, 2008
294
RWU987
2%
Iron Cratsman
Nov. 25, 2008
Dec. 31, 9999
762
