Demonstrates the construction process required to build the Crime Data Mart Design.
Пікірлер: 9
@clintondaniel52855 жыл бұрын
I've added the source code, source data, and documentation for creating the Crime Data Mart on GitHub here: github.com/cedanie2/ISM-4402
@abidvu24723 жыл бұрын
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?
@charbilrom31532 жыл бұрын
where were these videos during my semester ? I understand everything at last
@soarindragon6034 жыл бұрын
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.
@clintondaniel52854 жыл бұрын
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.
@akpofureenughwure61773 жыл бұрын
Hello Clinton! Thank you so much for this.. Is this the first video of this series?
@lahiru21003 жыл бұрын
Can we have this dataset please
@viktorkuznetsov78695 жыл бұрын
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!
@clintondaniel52855 жыл бұрын
I've added the source code, source data, and documentation for creating the Crime Data Mart on GitHub here: github.com/cedanie2/ISM-4402