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
/ anindianabroadd

[@krishchait6106]

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

[@TechCoach]

I am glad krish that I was able to help you :)

[@userstudent5099]

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-en1se]

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

[@javedabdool1187]

nice!

[@dadoll1660]

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

[@shivamshukla8753]

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?

[@TechCoach]

Sure Shivam, I will also recommend watching the indexing and partitioning series and I have one request from my end. Please help me promote by new channel by subscribing and sharing.
th-cam.com/video/HBQHekM1U2c/w-d-xo.html

[@souvikdatta8500]

Transaction table will have more number of records in telecom

[@TechCoach]

Indeed much more souvik

[@RandomTalesWithUs]

i think order item table is a more row..... plz correct me

[@TechCoach]

I will reverify but the tables are just for explaination purposes. They don't contain 100% precise data.
I have a small request I am working on this new channel " An Indian Abroad" and would really appreciate if you watch and subscribe to it.
th-cam.com/video/HBQHekM1U2c/w-d-xo.html

[@kiruthigaadaikkappan466]

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

[@vikaskumar-qr5tj]

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

[@TechCoach]

Hi Vikas , I am sorry I don't have anything related to telecom at this moment.
If I find something I will let you know

[@vikaskumar-qr5tj]

@Vivek Sure I will sit for the interview soon for informatica developer role so following some of your videos..

[@dharanisri4377]

Order items and transaction tables will have more rows

[@joyo2122]

the transaction table will have more rows

[@TechCoach]

Thats correct Joy

[@User_User_266o]

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

[@TechCoach]

Sure man , I will try to do the same.
I have a small request, Please help me in building this new channel "An Indian Abroad "
Please watch subscribe and share with your friends.
th-cam.com/users/AnIndianAbroadd
Your support is my motivation :)

[@firstupload68]

is grain and granualrity are same?

[@TechCoach]

Yes Siva

[@firstupload68]

@@TechCoach Thank you

[@abhishekmishra756]

Hello Sir can I get the ppt.??

[@sunnycatlover]

Fazoool