Load Relational DB

1) Create the "USCountyBusinessPatternsOLTP" DB + Tables.

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

2) A pictorial representation of loading the Relational DB:



3) Master package


    Loading "CountyBusinessPattern" table




4) Key highlights are in the video:

         

5) Score Card:

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

No comments:

Post a Comment