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? |