This would be the Transform step of the Extract Transform Load process.

"Joe H" wrote:

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