A time dimension is something you should not have to create on a nightly or incremental basis during execution of the existing data warehouse ETL.  Instead, here is some SQL to generate a time dimension for you.  Modify it as needed to suit your needs. /* Author/Co-author:Lawrence Patrick Email: [email protected] Object: SQL code; none Description:

Read more…