How to load OLTP data into Dimension and Fact table
Posted on 2013-06-07
I have a Dim Customer table and Dim Products table and a FactSaletable:
Dim Customer Table:
CustomerID AlternateKey CustomerName CustomerCompany
1 34525 James Boags Target
Dim Products table:
ProductID AlternateKey ProductType ProductName
1 345354 Large Ball
ID CustomerID(FK) ProductID(FK) Qty SalesAmount
1 1 1 2 $45
So I have created primary keys for all dimension tables which are foreign keys in the Fact table. Also a primary key for the fact table.
Now how am I suppose to load data into these tables from the OLTP database so items and
customer details are referenced accurately. I dont know how to relate the OLTP data to the fact tables so it references the Dim tables.
Please let me know if you need further details. Any help would be greatly appreciated.