Difference Between Fact Table and Dimension Table - Interview questions

A reality or fact table’s record could be a combination of attributes from totally different dimension tables. The Fact Table or Reality Table helps the user to investigate the business dimensions that helps him in call taking to enhance his business.
On the opposite hand, Dimension Tables facilitate the reality table or fact table to gather dimensions on that the measures needs to be taken.
The main difference between fact table or reality table and the Dimension table is that dimension table contains attributes on that measures are taken actually table.

[@nickjoseph2711]

I'm new to tech, and I can't tell you how much I appreciate you breaking this down with a pen and paper. So refreshing and clean and - most importantly - helpful. Thanks so much!

[@greatestvideos3496]

cool what brought you into tech

[@subramanianxganesan]

Very nice explaination, thanks sir, please keep it up.

[@gautamagarwal9761]

Best Explanation so far! So good ❤️

[@BCxxBC]

Thank you. This is one of the best videos' and explanations!

[@mantusingh7962]

Video is really osm.. and easy to understand.. expecting some more video on data warehouse.. Thank you so much

[@ayoninuoluwaoluwadare8679]

Thank you so much! This broke it down to the basics.

[@machasmania7532]

Please do more videos, it helps alot

[@NaveenKumar-fs5on]

thank you very much for clear and conscious video

[@mohmmedahmedazharimubaraka3671]

Thank you for this useful topic

[@gowthams.v6004]

Thanks you so much understood it clearly after watching your video

[@attitudeboy2840]

Thank you for your valuable information ☺️✅💕

[@neharaju13]

So so helpful!

[@saikrishnareddy6405]

Nice and simple way of explanation

[@yaswanthvema4314]

Excellent

[@amalpeters]

Nice Explanation

[@saran3784]

very clear and easy to catch bro.

[@dataworksstudio]

Thank you sir...it was really helpful! ✌️

[@saitejaaa1086]

Good Explanation

[@sourabhkalaskar]

good explanation thank you mr

[@anuragace6716]

Thanks for the understanding.

[@Kordloxefy]

are you saying the PK becomes the FK in the fact table? What about the source datatype in fact table?

[@premkumarn3093]

thanks for clarifying

[@TheRimaLifestyle]

Helpful info 👌

[@henriquejr7]

Thank you very much!!

[@tejusworld1343]

Thank you.. I Appreciate you

[@yaswanthvema4314]

How to reach you for more details. and i want to learn SSAS

[@shashpeiris6008]

Thanks, this helped me

[@varunmishra9507]

Thank you!!!

[@eazylarasan5071]

Thank You Soo Much

[@datastagebatch4480]

is there any duplicate values in dimension tables

[@muralimuthyala1965]

thank you very much

[@furkan-gx2er]

thanks a lot

[@travelwithbunty]

Hey can you help with Informatica I have 23 flat files and 4 fact tables for them and i need to convert that data to Oracle dataware House can you help how can i do!!!

[@xena8_8]

A more motivated & louder voice would make this easier to listen to 😅

[@macharlasv5284]

Thanks😊

[@fakhraldin8350]

yes

[@shivas3895]

is that mandatory a fact table must have FK of dimension table,Let's suppose I have a composite PK of 5 columnson my Dim table , so the fact should contain these 5 fk columns

[@Kordloxefy]

in the fact table it cannot contain al FK..