fact table and dimension table in data warehouse | Lec-8

In this lecture, I have talked about fact table and dimension table in data warehouse.
Directly connect with me on:- topmate.io/man...
Discord channel:- / discord
For more queries reach out to me on my below social media handle.
Follow me on LinkedIn:- / manish-kumar-373b86176
Follow Me On Instagram:- / competitive_gyan1
Follow me on Facebook:- / manish12340
My Second Channel -- / @competitivegyan1
Interview series Playlist:- • Interview Questions an...
My Gear:-
Rode Mic:-- amzn.to/3RekC7a
Boya M1 Mic-- amzn.to/3uW0nnn
Wireless Mic:-- amzn.to/3TqLRhE
Tripod1 -- amzn.to/4avjyF4
Tripod2:-- amzn.to/46Y3QPu
camera1:-- amzn.to/3GIQlsE
camera2:-- amzn.to/46X190P
Pentab (Medium size):-- amzn.to/3RgMszQ (Recommended)
Pentab (Small size):-- amzn.to/3RpmIS0
Mobile:-- amzn.to/47Y8oa4 ( Aapko ye bilkul nahi lena hai)
Laptop -- amzn.to/3Ns5Okj
Mouse+keyboard combo -- amzn.to/3Ro6GYl
21 inch Monitor-- amzn.to/3TvCE7E
27 inch Monitor-- amzn.to/47QzXlA
iPad Pencil:-- amzn.to/4aiJxiG
iPad 9th Generation:-- amzn.to/470I11X
Boom Arm/Swing Arm:-- amzn.to/48eH2we
My PC Components:-
intel i7 Processor:-- amzn.to/47Svdfe
G.Skill RAM:-- amzn.to/47VFffI
Samsung SSD:-- amzn.to/3uVSE8W
WD blue HDD:-- amzn.to/47Y91QY
RTX 3060Ti Graphic card:- amzn.to/3tdLDjn
Gigabyte Motherboard:-- amzn.to/3RFUTGl
O11 Dynamic Cabinet:-- amzn.to/4avkgSK
Liquid cooler:-- amzn.to/472S8mS
Antec Prizm FAN:-- amzn.to/48ey4Pj

[@hashaammasood1342]

I have seen multiple videos of Facts and Dimension but the way you explain it's so clean and clear with easy example

[@codewithovi997]

You are an outstanding teacher. They way you teach even a 5 year old will understand such a complex topic. Thank you so much for such valuable content

[@Genial_Gouthi]

I started watching your videos from yesterday, Planning to complete data ware house playlist by Today. Thank you so much your videos are really informative and I would definitely share your videos with my friends.

[@pratasaiprasad1109]

The way you explained was wonderful.

[@adhirajteotia7593]

waah sir wah....itni achi tarah se smjhaya hai aapne. Hats off...teacher bann jao sir, baccho ka future sahi ho jayega

[@shreyasarkar6970]

Was eagerly waiting for your video. You are just amazing and selfless Sir.Thanks a lot for such an awesome content.

[@Twilight6789]

You are just phenomenal 😲😃

[@prathammishra7844]

I am extremely impressed by the way of teaching sir such a neat and clean explanation😊

[@StringStack]

Best relatable example so far seen....🎉

[@khurshidhasankhan4700]

Bahut zabardast sir ek baar practical kr k bata dijiye, video ko dekhne me ek percent bhi boring nahi hoti hai

[@GrandPlaysOfficial]

Very nice explanation.

[@Radheykrishna576]

Very informative video. Thanks 🙏

[@mohdhammadkhan5570]

Was waiting for the video

[@Bbbbbbbbbbbb111]

well explained sir

[@StringStack]

Subscribed successfully ❤

[@mitukhan2775]

Very nice video sir🎉

[@deepikameher9343]

Nice explanation

[@jaibholenath553]

Sir kya aggregate table or fact table alg alg hai

[@abhinav1806]

How many videos will be there in this playlist?

[@beginner6715]

Bhai Watermarking and CDc Bata do interviews purpose ke liye. Clear nahi ho rha h 😢

[@amanpirjade9]

Kya Apache spark and Apache Kafka may coding karna padhe thi hai kya

[@manish_kumar_1]

Coding har jagah hai bhai. DE karna hai to coding karna parega

[@shyammaths5705]

bhai data engineer or python developer ?? career growth??

[@manish_kumar_1]

Both has a good career growth

[@meena.123.]

Explain fact table with its type Ans: * fact table is database table in data warehouse that is store contative information for analysis *fact table is center table of star and snow flack schema *fact table typically have two column forign key to dimesion table *fact table contain only numerical data *primary key of each dimesion table is part of fact table *fact table conncted to dimesion table though the forign key _____ There are three type of fact table 1 addictive 2 semi addictive 3 non addictiive

[@AjaySinha-g9e]

Driving table ka matlab kya hota h ?

[@manish_kumar_1]

I think it's fact table only. Just confirm once

[@pbhaskar5197]

Please translate videos in English