What are Junk dimensions?

A Junk Dimension is a dimension table consisting of attributes that do not belong in the fact table or in any of the existing dimension tables. The nature of these attributes is usually text or various flags, e.g. non-generic comments or just simple yes/no or true/false indicators.
The have low cardinality and usually don't come under SCD.
If you require any clarifications for this video, Please drop me a comment and I will try to answer asap.
#Junkdimension #datawarehousing #techcoach

[@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

[@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

[@helloranjan89]

Very nice explanation

[@TechCoach]

Thanks Ranjan :)

[@TheWatcherMilan]

Bro.. awesome video..

[@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

[@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 :)

[@prakashnt7014]

Thanks for great video bro

[@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.

[@yarramneediravindraswamy6804]

content is good but sound is very low sir

[@beesmarter9348]

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

[@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

[@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.

[@Clentical]

How can I contact you or reach you ??

[@joyo2122]

WOW

[@TechCoach]

Thanks a lot Joy

[@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