DWH Interview Question : Granularity in Datawarehousing

The video explains an important interview question what is granularity in DWH.
The granularity of a table is the finest level of detail it contains, while creating a fact table it is of vital importance to understand which dimensions will form that fact table or in other terms what is the lowest level of detail that can be fetched from the fact table.
The video explains the same with real project examples
Please do help me in building this new channel

[krishchait]

I have cracked several interviews by watching your videos.
When i speak exactly how you mention in your videos, the interviewers were themselves speechless at my clarity. All because i have remembered what you mentioned in your videos.
Thank you for the detailed videos

[userstudent]

Thanks is a small word for you... may god bless you I recently started watching your videos and my concepts are far clear than before.. keep Going u are doing amazing job...

[sagarkumar-ense]

Hi Vivek,
Thanks for this video.Can you please make video on while we add any new column to a fact table, how to check the granularity based on the source mapping comluns and join conditions

[dadoll]

is identifying grains somehow help you to identify, as well, your natural keys in dimensions?

[vikaskumar-qrtj]

Hi Vivek can you refer some telecom domain based informatica project mini which I can do on my own??

[RandomTalesWithUs]

i think order item table is a more plz correct me

[shivamshukla]

Vivek-first thank you so much for such videos and i have one request, Can you please make a series on Oracle query optimization /performance tunning?

[kiruthigaadaikkappan]

Order items will have more records than orders table. And grain of item table is what product and how much quantity ordered.

[souvikdatta]

Transaction table will have more number of records in telecom

[User_User_o]

sir smjh nae i....will uh plzzz explain again in more comprehensive way...

[dharanisri]

Order items and transaction tables will have more rows

[joyo]

the transaction table will have more rows