Load Data warehouse

1) Create the "USCountyBusinessPatternsDW" DB + Tables.

    (If you have not created the DB + Tables...Please refer to Requirements + Download files page)

2) A pictorial representation of loading the USCountyBusinessPatternsDW:

3) Master package

   Load "FactCountyBusinessPattern" table using Lookups

4) Key highlights are in the video:

             

5) Score Card:

                 Number of records loaded: 30+ million rows
                 Time taken to load: under 6 minutes
                 System: MacBook Pro
                              Dual booting with Windows 8 Pro & Mac OS
                              500 GB SSD
                              8 GB RAM