README.md

DateAndTimeDimensionBuilders

Date dimension and time dimension builders for data warehousing written in Python.

Date Dimension Builder (datedimensionbuilder.py)

$ python datedimensionbuilder.py --help
usage: datedimensionbuilder.py [-h] [-f FILE] [-s DATE] [-e DATE] [-c]

Build a Date Dimension for use in a Data Warehouse or Data Mart. The output
will be written to stdout unless a CSV file is specified with the -f/--file
option.

optional arguments:
  -h, --help            show this help message and exit
  -f FILE, --file FILE  write output to a CSV file.
  -s DATE, --startdate DATE
                        starting date of the date dimension. Default is
                        1/1/1850.
  -e DATE, --enddate DATE
                        ending date for the date date dimesnion. Default is
                        12/31/2050.
  -c, --columnnamesonly
                        output column names only.

Time Dimension Builder (timedimensionbuilder.py)

$ python timedimensionbuilder.py --help
usage: timedimensionbuilder.py [-h] [-f FILE]

Build a Time Dimension for use in a Data Warehouse or Data Mart. 
The output will be written to stdout unless a CSV file is specified with the -f/--file 
option.

optional arguments:
  -h, --help            show this help message and exit
  -f FILE, --file FILE  write output to a CSV file