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?
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.
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.
I've added the source code, source data, and documentation for creating the Crime Data Mart on GitHub here: github.com/cedanie2/ISM-4402
where were these videos during my semester ? I understand everything at last
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?
Hello Clinton! Thank you so much for this.. Is this the first video of this series?
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.
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.
Can we have this dataset please
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!
I've added the source code, source data, and documentation for creating the Crime Data Mart on GitHub here: github.com/cedanie2/ISM-4402