What are Junk dimensions?

[@TechCoach]

Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends kzbin.info

[@w0nderw0manjy]

You are really great 👍

[@TechCoach]

@@w0nderw0manjy thanks Jyoti .. this is very kind of you :)

[@MegaPray]

Thanks Vivek, your videos are really informative and simple to understand, thanks again.

[@mosestes9417]

it is very clear and easily understandable but please the volume is little bit low if possible please add a volume little bit so that it will be more clear, thanks lot.

[@TechCoach]

+Moses Tes Thanks a lot, I shall try and add subtitles :)

[@pavitramahale7756]

Very simple and easy to Understand. Thanks!!

[@TechCoach]

Thanks Pavitra for the kind words. This video on datamart may interest you as well. kzbin.info/www/bejne/noianKF4jZh-d5I

[@helloranjan89]

Very nice explanation

[@TechCoach]

Thanks Ranjan :)

[@13lebanese]

what if there is a future requirement to add new dimension. how do we add it to the junk dimension table without changing the existing surrogate key? say i have another mini dimension table that stores pk from fact table with its junk dimension key and a snap date. if there is a new dimension to be added to the junk table, how do we backfill the historical data?

[@TechCoach]

That's an interesting question, I have never personally came across this scenario myself. Let me think over and research the best solution and I will get back to you.

[@nidhisingh4973]

@@TechCoach Hi Vivek, did u get an answer for this?

[@tonee84]

Interested too.

[@shreyaspatil4861]

This is really good, very clear explanation, thanks for creating these. I'm learning about data warehousing and was looking for videos for real examples. I'm going to watch the entire playlist you have created on data warehousing.

[@TechCoach]

Thanks Shreyas for the kind words, If you need any more help please do let me know

[@TheWatcherMilan]

Bro.. awesome video..

[@sujaa1000]

Thank you again Vivek, it was very helpful. Regards, Sujaa

[@TechCoach]

Wow , I am glad you are watching all the videos. I will make it a point to work on the collection video soon :)

[@fashion22102008]

Hi vivek, your videos are very informative..can you make a video explaining hierarchical dimensions as well...thanks

[@TechCoach]

Thanks a lot for the kind words, I have planned a video on Hierarchies may be that will help

[@prakashnt7014]

Thanks for great video bro

[@ThanhNguyen-mb2lg]

I prefer keeping this as constant or enum in the application side, but i can see this being use when multiple app access same warehouse/mart

[@Clentical]

How can I contact you or reach you ??

[@cppmsg]

Why exactly should a "junk dimension" be of low cardinality? The smallest storable unit in a DB is one byte, that allows 255 values (+1). Is that low cardinality? When does it become too large? It seems the UI may become more complex when selecting which combination is to be searched for, but again that can be handled with UI logic. One million does seem large, but again that is easily stored in 32 bits.

[@beesmarter9348]

thank you.. find the exact want I want to know

[@yarramneediravindraswamy6804]

content is good but sound is very low sir

[@utsachatterjee]

Is this channel still on?

[@TechCoach]

It is Ipsita and you can expect a lot of new videos soon.

[@utsachatterjee]

Okay. Looking forward to it. Just a recommendation: it would be of great help for me if you can show real time implementation.(am a DS developer) curious to learn more

[@joyo2122]

WOW

[@TechCoach]

Thanks a lot Joy