Thread: Fact Tables
View Single Post

   
  #1 (permalink)  
Old 05-07-2008, 10:15 AM
Joe H
 
Posts: n/a
Default Fact Tables

Was looking at Kimball SSIS templates and note that when he is updating Fact
tables, he first dumps the original extract into an "extract" table, then in
a 2nd Data Flow area inside the same control flow, pulls that data and lines
it up with the dimension(s).

I think he's only doing it this way for auditing reasons - is this the norm
or are there other reasons to do it this way?


Reply With Quote