#etlqalabs #datawarehousingconcept #etltesting In this session - we will understand what is difference between fact and dimension in data warehousing . Also in detail explanation about fact and dimension tables.
Пікірлер: 32
@ArifRaza9 ай бұрын
Thanks a lot sir. Wonderful explanation!
@sonurawat70692 жыл бұрын
first of all thank you so much sir for this usefull video. please make 1 video on snowflake schema in a similar way.
@koppalakalyan82562 жыл бұрын
Thank you for the information sir
@saudaminideshmukh22722 жыл бұрын
thank you sir, well explained
@prateekchokkara39972 жыл бұрын
Hi sir, very informative video. I know u sir we were working in Business One technologies.
@etlqalabs50482 жыл бұрын
Hey Prateek, Good to see you here. Keep learning and keep sharing
@prateekchokkara39972 жыл бұрын
@@etlqalabs5048 Thanku sir.
@shobharanipoojari35692 жыл бұрын
Hii sir thanks for all information .plese explain only flat file validation topic
@akshaykumarannigeri24582 жыл бұрын
Sir as a etl tester we should check both dimension tables and fact tables with source data or only we have to check fact tables with source data? Please reply
@waseemAkram-qc2vm2 жыл бұрын
Hi sir, this 4 videos in datawarehouse playlist covers all data warehouse concepts or any additionally need to learn after this 4 videos to cover all datawarehouse concept
@etlqalabs50482 жыл бұрын
Hi Waseem , These are foundation videos to begin , I will add more to the list when time permits
@waseemAkram-qc2vm2 жыл бұрын
@@etlqalabs5048 thank you so much sir it's helps alot for new learns
@ashokrajann93512 жыл бұрын
Hi sir What is the difference between Data warehousing testing Database testing ETL testing Is the above all 3 comes under functional testing?
@etlqalabs50482 жыл бұрын
Please Watch recent upload for these questions
@SwaKaran Жыл бұрын
Hello sir I have been watching your videos ....this is helping me a lot to understand ETL...is there any chance to talk to you?
@techwellness61422 жыл бұрын
In the Last query near end of video , why is 'JOIN' not being used ? Isnt that incorrect?
@divyanshtrivedi77162 жыл бұрын
if number of rows r more in fact table then dimension why it's called vertical table it shld be horizontal??
@DeepakKumar-sh6hl2 жыл бұрын
which tables are loaded first fact or dimension and why ?
@etlqalabs50482 жыл бұрын
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
@DeepakKumar-sh6hl2 жыл бұрын
@@etlqalabs5048 thankyou so much for answering
@pmk_full_facts_32242 жыл бұрын
What is top down approach and bottom apprach
@etlqalabs50482 жыл бұрын
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
@pmk_full_facts_32242 жыл бұрын
Yes cleared bro.
@pmk_full_facts_32242 жыл бұрын
Thank you soo much
@kopurirajesh13472 жыл бұрын
How we can do validation testing in dimensional table?
@Psychoche152 жыл бұрын
Sir can you provide PDF notes along with vedio
@vinodkolar21902 жыл бұрын
Sir, can you please do video on real time project?
@etlqalabs50482 жыл бұрын
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
@vinodkolar21902 жыл бұрын
@@etlqalabs5048 real time project on ETL testing
@etlqalabs50482 жыл бұрын
@@vinodkolar2190 great then please watch my ETL Testing playlsit on this channel itself, hope you will find good stuff