Тёмный
No video :(

Fact Tables and Types of fact tables 

Tech Coach
Подписаться 34 тыс.
Просмотров 67 тыс.
50% 1

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

 

29 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@rawoofs9027
@rawoofs9027 3 года назад
Types of fact tables,Periodic Snapshot table, Accumulated Snapshot, Factless Fact Table,Aggregate Table(Cal tables/Cubes)
@murugskarmegam7174
@murugskarmegam7174 2 года назад
Transactional Fact Tables
@subhojyotiganguly7029
@subhojyotiganguly7029 3 года назад
can you show how fact table loaded from odc and data flow to oltp to ods?
@02vikassoni
@02vikassoni 4 года назад
Please make a video on PRAGMA COVERAGE,DEPRECATE,INLINE,RESTRICT_REFERENCES.
@manish0589
@manish0589 6 лет назад
very good explaination thanks
@TechCoach
@TechCoach 6 лет назад
Thanks for the kind words, I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html
@459sara9
@459sara9 6 лет назад
Good explanation.. Thanks Vivek!
@AnIndianAbroadd
@AnIndianAbroadd 6 лет назад
Saravana Kumar Thanks a lot for the kind words :). I am making this new youtube channel. Please check it out and subscribe as well :) ru-vid.com/show-UCoLdaMxhfDgdgIAcRGlUvkg
@shrutisinghal8556
@shrutisinghal8556 6 лет назад
Thanks Vivek. Your videos are very informative.
@sujaa1000
@sujaa1000 4 года назад
Thank you again! And I subsribed to "An Indian Abroad " Regards, Sujaa
@mehulsorathiya6228
@mehulsorathiya6228 6 лет назад
Very good explanation...!!
@TechCoach
@TechCoach 6 лет назад
Mehul Sorathiya Thanks a lot :)
@TechCoach
@TechCoach 6 лет назад
Hey Mehul, I have a small request I am working on tgis new youtybe channel and would really appreciafe if you watch and subscribe to it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html
@snowflakehelpers4600
@snowflakehelpers4600 4 года назад
Too good brother
@TechCoach
@TechCoach 4 года назад
Thanks Sanjeev for the kind words :)
@avik999
@avik999 6 лет назад
Vivek, very helpful videos... Thanks a lot man.
@TechCoach
@TechCoach 6 лет назад
Thanks for the kind words, I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html
@sachingond3229
@sachingond3229 2 года назад
Am i correct in saying that pariodic snapshot fact table present in edwh along with Transactional fact table only!! If yes then is that a galaxy schema?? If not then where do we place this pariodic fact table along with transactional fact table??
@smirthi3693
@smirthi3693 2 года назад
Hi Sachin, can you please share with us if you have got the answers for your above questions?
@snehakavinkar2240
@snehakavinkar2240 3 года назад
What/when is the ideal way to update the aggregate fact table? Can we define a trigger on the source table and update the destination fact table for every record inserted in the source or is it a bad idea?
@TechCoach
@TechCoach 3 года назад
Yes, you don't want to engage your fact table for DML that frequently, you can update it as a part of a batch process.
@Happymoon789
@Happymoon789 6 лет назад
Thanks, it’s help
@TechCoach
@TechCoach 6 лет назад
+Julie Jiang you are welcome :)
@mosestes9417
@mosestes9417 6 лет назад
Can we aggregate two or more fact tables? how?
@sanghamitramishra1047
@sanghamitramishra1047 5 лет назад
Thanks
@TechCoach
@TechCoach 5 лет назад
Thanks Sanghamitra for the kind words. I have a small request, I am working on this new channel please do watch and subscribe to it. Your support is my motivation. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oz4TbQwrrOY.html
@ashokboyina2979
@ashokboyina2979 6 лет назад
what is surrogate key?
@IntraFinesse
@IntraFinesse 4 года назад
This is a good description: www.bcarter.com/intsurr1.htm
@jagansayam9386
@jagansayam9386 3 года назад
Trasactional fact table was not very clear
@TechCoach
@TechCoach 3 года назад
I am sorry Jagan, Transaction fact are like your order or sales table where you capture details of every single order or sales. They can have millions of rows added in a day for a big organization. If you feel I was helpful. Please consider subscribing to my other channel as well . ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6G1xGi-D5ow.html
@ajitghule3033
@ajitghule3033 5 лет назад
Can we have text attributes in fact table?
@nageshkonda5481
@nageshkonda5481 4 года назад
No text attributes in fact table
@jojappakoyyuru8301
@jojappakoyyuru8301 3 года назад
no
@celinehm9630
@celinehm9630 2 года назад
Can we contact u by mail if i didn't understand something please ?
Далее
What are Junk dimensions?
10:46
Просмотров 21 тыс.
Star and Snowflake schema explained with real scenarios
22:58
Женщина на опознании
00:11
Просмотров 13 тыс.
Woman = best friend🤣
00:31
Просмотров 4,1 млн
Dimension & Fact Tables
31:17
Просмотров 42 тыс.
Dimensional Modeling
53:54
Просмотров 167 тыс.
Dimensional Modeling - Declaring Dimensions
55:32
Просмотров 24 тыс.
7 Different Types of Dimensions in a Data Warehouse!
8:56
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34