Difference between FACT and DIMENSION in Data Warehousing | dimensional modelling in data warehouse 

Hi Waseem , These are foundation videos to begin , I will add more to the list when time permits

@@etlqalabs5048 thank you so much sir it's helps alot for new learns

Please Watch recent upload for these questions

Dimension table is loaded first and then fact . The reason behind is fact table contents foreign key from fact table which is primary key in dimension table and due to referential integrity we need to load the table with primary key and then then table containing foreign key to avoid data load rejection. Hope this helps

@@etlqalabs5048 thankyou so much for answering

Hey Prateek, Good to see you here. Keep learning and keep sharing

@@etlqalabs5048 Thanku sir.

Top down and bottom up are data warehouse design method , it's part of data warehousing concept. Let me explain you a bit here 1) Top down approach- data warehouse is built first and then specific datamarts are build E.g company ( Data warehouse) then then each department in company like sales , HR, Marketting etc can be considered as datamarts However In Bottom up approach , datamarts are deisgned first and then data warehouse , you can consider the same example for data warehouse and datamarts as in top down approach, hope this is clear

Yes cleared bro.

Thank you soo much

How we can do validation testing in dimensional table?

Sorry , please eloborate your request so I can understand on what topic do you need me to do video ? If you are looking for real time scenarios in ETL Testing, do watch ETL Testing be playlist

@@etlqalabs5048 real time project on ETL testing

@@vinodkolar2190 great then please watch my ETL Testing playlsit on this channel itself, hope you will find good stuff