Fact Table

1
Fact Table
2
FactCreate

• SELECT Customer.CustomerNumber, Orders.OrderDate,
  OrderLine., SalesRep.SakesRepNumber
• INTO Fact
• FROM SalesRep INNER JOIN (Part INNER JOIN
  ((Customer INNER JOIN Orders ON
  Customer.CustomerNumber Orders.CustomerNumber)
  INNER JOIN OrderLine ON Orders.OrderNumber
  OrderLine.OrderNumber) ON Part.PartNumber
  OrderLine.PartNumber) ON SalesRep.SakesRepNumber
  Customer.SalesRepNumber

3
Add Surrogate Key Column

• ALTER TABLE Fact ADD COLUMN CustomerKey NUMBER

4
Update Surrogate Key

• UPDATE Fact, CustomerSurrogates
• SET Fact.CustomerKey CustomerSurrogates.Customer
  Key
• WHERE CustomerSurrogates.CustomerNumber
  Fact.CustomerNumber

5

• ALTER TABLE Fact DROP CustomerNumber