Тёмный

Difference Between Fact Table and Dimension Table - Interview questions 

Informatica Interview
Подписаться 1,4 тыс.
Просмотров 121 тыс.
50% 1

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.

Опубликовано:

 

12 сен 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 40   
@nickjoseph2711
@nickjoseph2711 2 года назад
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
@greatestvideos3496 2 года назад
cool what brought you into tech
@gautamagarwal9761
@gautamagarwal9761 Год назад
Best Explanation so far! So good ❤️
@subramanianxganesan
@subramanianxganesan 3 года назад
Very nice explaination, thanks sir, please keep it up.
@ayoninuoluwaoluwadare8679
@ayoninuoluwaoluwadare8679 2 года назад
Thank you so much! This broke it down to the basics.
@BCxxBC
@BCxxBC 2 года назад
Thank you. This is one of the best videos' and explanations!
@dataworksstudio
@dataworksstudio 3 года назад
Thank you sir...it was really helpful! ✌️
@attitudeboy2840
@attitudeboy2840 Год назад
Thank you for your valuable information ☺️✅💕
@mantusingh7962
@mantusingh7962 2 года назад
Video is really osm.. and easy to understand.. expecting some more video on data warehouse.. Thank you so much
@saran3784
@saran3784 2 года назад
very clear and easy to catch bro.
@NaveenKumar-fs5on
@NaveenKumar-fs5on 2 года назад
thank you very much for clear and conscious video
@saikrishnareddy6405
@saikrishnareddy6405 2 года назад
Nice and simple way of explanation
@machasmania7532
@machasmania7532 3 года назад
Please do more videos, it helps alot
@gowthams.v6004
@gowthams.v6004 2 года назад
Thanks you so much understood it clearly after watching your video
@sourabhkalaskar
@sourabhkalaskar 2 года назад
good explanation thank you mr
@travelwithbunty
@travelwithbunty 3 года назад
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!!!
@datastagebatch4480
@datastagebatch4480 2 года назад
is there any duplicate values in dimension tables
@anuragace6716
@anuragace6716 3 года назад
Thanks for the understanding.
@mohmmedahmedazharimubaraka3671
Thank you for this useful topic
@tejusworld1343
@tejusworld1343 3 года назад
Thank you.. I Appreciate you
@TheRimaLifestyle
@TheRimaLifestyle 2 года назад
Helpful info 👌
@yaswanthvema4314
@yaswanthvema4314 3 года назад
How to reach you for more details. and i want to learn SSAS
@Kordloxefy
@Kordloxefy 11 месяцев назад
are you saying the PK becomes the FK in the fact table? What about the source datatype in fact table?
@premkumarn3093
@premkumarn3093 3 года назад
thanks for clarifying
@docokd7oco443
@docokd7oco443 10 месяцев назад
It is interesting the microsucks wont allow candidate and/or composite keys in relationship data modeling.
@yaswanthvema4314
@yaswanthvema4314 3 года назад
Excellent
@henriquejr7
@henriquejr7 2 года назад
Thank you very much!!
@neharaju13
@neharaju13 11 месяцев назад
So so helpful!
@amalpeters
@amalpeters 10 месяцев назад
Nice Explanation
@saitejaaa1086
@saitejaaa1086 2 года назад
Good Explanation
@shashpeiris6008
@shashpeiris6008 2 года назад
Thanks, this helped me
@furkan-gx2er
@furkan-gx2er 5 месяцев назад
thanks a lot
@eazylarasan5071
@eazylarasan5071 2 года назад
Thank You Soo Much
@macharlasv5284
@macharlasv5284 3 года назад
Thanks😊
@muralimuthyala1965
@muralimuthyala1965 2 года назад
thank you very much
@varunmishra9507
@varunmishra9507 Год назад
Thank you!!!
@fakhraldin8350
@fakhraldin8350 3 года назад
yes
@xena8_8
@xena8_8 2 года назад
A more motivated & louder voice would make this easier to listen to 😅
@shivas3895
@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
@Kordloxefy 11 месяцев назад
in the fact table it cannot contain al FK..
Далее
How is data mart different from data warehouse?
6:32
Просмотров 3,3 тыс.
Телеграмм-Колян Карелия #юмор
00:10
Beautiful sport😍
00:20
Просмотров 201 тыс.
Fact table and Dimension table | Data Warehousing
7:56
Fact & Dimension tables in Power BI | Data Modelling
15:07
Star and Snowflake schema explained with real scenarios
22:58