Data Mart Design - Table Construction

Demonstrates the construction process required to build the Crime Data Mart Design.

[@clintondaniel5285]

I've added the source code, source data, and documentation for creating the Crime Data Mart on GitHub here: github.com/cedanie2/ISM-4402

[@abidvu2472]

Thank you Clinton for a very concise and useful tutorial for SSIS. By the way, i'd appreciate it if anyone can help me on explaining further how I can build a staging table?

[@charbilrom3153]

where were these videos during my semester ? I understand everything at last

[@soarindragon603]

Hi Clinton, May I ask why you added a foreign key for state in the city table? Why not just create a location dimension with all location data in it? It does not look like state would be an outrigger dimensions of city. It looks like normalizing (snowflaking) which as far as I know you should not do. Thank you.

[@clintondaniel5285]

Soarin Dragon good question. It would be perfectly acceptable to create a Location dimension with both State and City. But, in this case I was just trying to demonstrate to students an example of how you can build dimensions with a hierarchy. State and City are just an easy example to understand the concept.

[@akpofureenughwure6177]

Hello Clinton! Thank you so much for this.. Is this the first video of this series?

[@lahiru2100]

Can we have this dataset please

[@viktorkuznetsov7869]

Clinton Hi! Where I can get source table just like yours? I searched for that table at data.gov and didn't found aggregated table as you have. Thanks!

[@clintondaniel5285]

I've added the source code, source data, and documentation for creating the Crime Data Mart on GitHub here: github.com/cedanie2/ISM-4402