These series of Data Warehouse videos is one of the most interesting and educational on the subject that I have ever seen. Thanks !
@mrgogate
6 ай бұрын
Thank you!! and glad videos were useful.
@lesterlino3316
2 жыл бұрын
Quick question: When you do the joins to populate the Fact table, you use the Dim tables, but also, a table from the data source. I think there is not other way to do it, right? is that a common practice in real life? (to do the joins using tables that belong to one database/schema -staging-, and adding tables to the join, that belong to a different data base/schema -data source-)? Thanks again for create and share this excellent material!
@nilamsherkar
Жыл бұрын
Very nice explanation
@parupatel3108
2 жыл бұрын
Thank you Mandar!! I saw your whole Data Warehouse video series. It's wonderful !! Learnt a lot from this. If possible can you please make a video on SCD 2 (maintaining history) for an existing Employee/Department example.
@mrgogate
2 жыл бұрын
I will do it in first week of December..
@parupatel3108
2 жыл бұрын
@@mrgogate Thanks a lot !! :)
@PradeepKanaparthy
Ай бұрын
If it is incremental load on a daily basis, we will get new records and updated records to load in dimension table. Since ID(s) gets duplicated in dimension tables, on every insert into fact table, we will get those all duplicates every time we load into fact table on daily basis. If you can filter data by latest/active record to insert into fact table.
@oyilatechnology
2 жыл бұрын
Thanks Brother, Great Job how do will handle many to many , 2 or 3 fact in where house ,loading data and table structure
@Eldo_thomasbaby
Жыл бұрын
Good one
@tariktv1
Жыл бұрын
This is loading by pure sql. Can you use SSIS and using scd for loading dim tables?
@ericsos101
2 жыл бұрын
Great video and well explained in details .. Can you share dataset please
@mrgogate
2 жыл бұрын
Please check following video for dataset...kzitem.info/news/bejne/y61uz6ynnJx9hno&ab_channel=MandarGogate
@nanajama4537
2 жыл бұрын
Can you share the doc you're referencing in the beginning, please? This is great info. New Subscriber here :)
@mrgogate
2 жыл бұрын
Here you go - github.com/magogate/DataWarehouse_And_Reporting good luck 👍
@nanajama4537
2 жыл бұрын
@@mrgogate Nice! Thank you.
@srishtibhat6532
2 жыл бұрын
Hi Mandar,suppose our data is missing on few days we want to check before loading into fact table.Can you make a video on the same.
@mrgogate
2 жыл бұрын
Hi Srishti.. did you mean that DW job did not run for some time? if that's the case.. moment you will start the job -- it will pull records from same date where it ran last time..
@srishtibhat6532
2 жыл бұрын
@@mrgogate hey mandar,it's more likely,data is coming through pipeline to fact table,if suppose there's no data or some missed data,if we have a condition there it will check is null or not something like that if null it won't load to fact if not it will.
@oyilatechnology
3 жыл бұрын
it will be good if we have the excel to follow you as a practice , where can l see the data file sir
@mrgogate
3 жыл бұрын
Please check video -- kzitem.info/news/bejne/y61uz6ynnJx9hno
@mrgogate
3 жыл бұрын
you will also find csv files at github.com/magogate/DataWarehouse_And_Reporting
@krishnakumar-vi3tf
3 жыл бұрын
nce video's Mandar,i see why we ignored populating date key's in fact table, how are we going to utilize the time dimension, could you please give some insight in to that!!
@mrgogate
2 жыл бұрын
Hi Krishna.. date dim I have connected with Emp Dim not with fact.. you can do it either way.. but in this scenario I did not populate dates till fact.. please check video kzitem.info/news/bejne/t4ZttaFtgGR2nn4
@juanodonnell
7 ай бұрын
why doesn't the fact table have its own primary key?
@aakrititimilsina7662
3 жыл бұрын
Thank you very much
@mrgogate
2 жыл бұрын
I am glad it was helpful!
@ericsos101
2 жыл бұрын
Why didn’t you include DimDate into your fact table creation?
@mrgogate
2 жыл бұрын
Hi Eric.. date dim I have connected with Emp Dim not with fact.. you can do it either way.. but in this scenario I did not populate dates till fact.. please check video kzitem.info/news/bejne/t4ZttaFtgGR2nn4
@ongpytran4552
3 жыл бұрын
Thank u so much
@mrgogate
3 жыл бұрын
Thank you!
@toqasalah9424
Жыл бұрын
do any one have the code he has write in the video, please 😂?
@mrgogate
Жыл бұрын
you will find it at github.com/magogate/DataWarehouse_And_Reporting
Пікірлер: 34