Sherry's BI Corner

Now we understand that the ETL process is really the ECCD process. As a ETL developer, we understand the staging (or storage) area needs to be carefully designed. We often wondering what to do with those in-between data. Do we permanently store them, semi-permanently store them, archive them, keep one cycle copy, etc?

Here are some discussion about this topic at each of the major four steps of ETL in the ETL Toolkit book.