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

[@ayoninuoluwaoluwadare8679]

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

[@gautamagarwal9761]

Best Explanation so far! So good ❤️

[@BCxxBC]

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

[@subramanianxganesan]

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

[@dataworksstudio]

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

[@machasmania7532]

Please do more videos, it helps alot

[@anuragace6716]

Thanks for the understanding.

[@mantusingh7962]

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

[@attitudeboy2840]

Thank you for your valuable information ☺️✅💕

[@NaveenKumar-fs5on]

thank you very much for clear and conscious video

[@saran3784]

very clear and easy to catch bro.

[@gowthams.v6004]

Thanks you so much understood it clearly after watching your video

[@saikrishnareddy6405]

Nice and simple way of explanation

[@tejusworld1343]

Thank you.. I Appreciate you

[@sourabhkalaskar]

good explanation thank you mr

[@TheRimaLifestyle]

Helpful info 👌

[@mohmmedahmedazharimubaraka3671]

Thank you for this useful topic

[@premkumarn3093]

thanks for clarifying

[@henriquejr7]

Thank you very much!!

[@neharaju13]

So so helpful!

[@yaswanthvema4314]

Excellent

[@varunmishra9507]

Thank you!!!

[@amalpeters]

Nice Explanation

[@eazylarasan5071]

Thank You Soo 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!!!

[@macharlasv5284]

Thanks😊

[@shashpeiris6008]

Thanks, this helped me

[@muralimuthyala1965]

thank you very much

[@datastagebatch4480]

is there any duplicate values in dimension tables

[@yaswanthvema4314]

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

[@saitejaaa1086]

Good Explanation

[@Kordloxefy]

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

[@fakhraldin8350]

yes

[@xena8_8]

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

[@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..