SSIS Theory

Last Post 05 Jul 2007 06:18 AM by Johnslg. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Johnslg
New Member
New Member

--
05 Jul 2007 06:18 AM
In Ms. Poolet's article in the July issue on data warehouse table design she recommends using identity fields in all one's tables. This sounded great to me until I started thinking about loading data. I have three basic tables:

factSales
SalesKey <pk> identity
TimeKey <fk> int,null
TypeKey <fk> int,null
SalesAmount money

dimTime
TimeKey <pk> identity
SalesDate

dimType
TypeKey <pk> identity
TypeOfSale int,null

I am going to load data from an SQL OLTP db to my OLAP with SSIS. I can easily populate each table but I don't know how to get the dimemsion table key fields into the fact table as foreign keys. If I load the dimensions first then do I lookup into the dimension table and build a fact table for each key? Or do I read my source data and build three tables each time I read a new row? Or is there something I am missing?

Thanks.

John
You are not authorized to post a reply.

Acceptable Use Policy