dwh

The Time Dimension Structure and Loading script for SQLServer

  • Star
  • Star
  • Star
  • Star
  • Star

 

In a Data Warehouse there are a number of common dimensions such as Geographic and Time. 

I leave here a script to create the Time Dimension table and a procedure to loading it between two dates:

 

/ * Destination database * /

use PAnalisys