Why do we need Junk Dimension | Data Warehouse Concepts

We are going to talk about Junk Dimension- what is junk dimension, why do we create junk dimension.
A junk dimension is a collection of random transaction codes flags and/or text attributes that are unrelated to any particular dimension. By creating a junk dimension, we remove the flags from the fact table and place them into a useful dimensional framework.
Please share your thoughts and feedback.
Thanks for watching.
For more information, please visit www.aroundBI.com

[@Ronitkable]

I would like to correct one thing here is 'Junk Dimension tables contain a surrogate key that fact table uses to reference the row. Basically, fact table contains a foreign key to rows in Junk Dimension table' Your diagram shows surrogate key part of Fact table. Rest, really good and well explained video.

[@AmyXu-q3k]

Very clear and logical explanation, thanks!

[@robertjohnson5838]

At 4:40, While you said "Four indicators that take on 3 values..." and your 3**4 is consistent with that, you actually have 4 in the Values portion and 3 in the Indicators portion, and if THAT were true it would be 4**3 = 64.

[@tariqawan5279]

Very Nice Explanation. Thanks

[@329smh]

Very well explained..would love to see similar video on "Mini Dimension" as well.

[@makarandnidhalkar7139]

brilliantly explained. thanks

[@rammadipeddi5864]

Can you please do video on interview point of view with most expected questions please

[@AkshuGotuDance]

Excellent Explanation Thanks

[@rahasyagumnam7806]

Why can't store type be one of the attributes of store dimension rather than being a junk dimension?

[@nitagawade3330]

Excellent

[@mohitrock100]

Great Tutorial . Very Nicely Explained .

[@AnilJacobs]

Never thought about this, thanks! How do you maintain them in Datawarehouse? Must we frequently check new values in fact tables at ETL time and keep it updated every time?

[@hatemelshesheny814]

Really helpful video

[@CevicheChessSalsa]

Very nice explanation, thanks so much!

[@gtm6505]

Thanq very informative

[@travel_the_world252]

Good explanations thank you

[@roopbasant20031]

Good explanation

[@venkateshreddy2137]

Thanks for detailed explanation.

[@highcontrast4488]

nice

[@pritammishra9850]

amazing tutorial

[@ziedx5]

Thanks, nice explanation

[@acidforblood]

I'm fuzzy on the definition of indicators in the context of a Junk Dimension. I also lack experience with the terminology. Would indicators be the columns or fields in question that hold the combinations of values?

[@shaliniguha1822]

Basically the columns like payment type, store type etc and the unique values are the possible values they can hold.

[@dineshreddy1478]

Perfect Thanks

[@getusama]

please can you show what the Junk Dimension actually look like for the example you have explained?

[@hamedhussaini1541]

I guess it will look like a table with every possible combination of values, I would rather ask how do we go about creating it. Is there any automatic way of creating it or is it going to be a manual process. By the way its been long time, where are you and how have you been? message me personally.

[@MyLove-uo3bw]

3:25 Definition

[@prouser7080]

meri english khrab ho gyi