What is Junk Dimension in Data Warehousing?

Last Post

RSS

Posts: 18

Deepak Raj

Guest

Topic starter

Aug 29, 2020 7:29 am

(@Deepak Raj)

Active Member

Joined: 4 years ago

What is the purpose of a junk dimension in data warehousing and how it is useful?

Topic Tags

junkdimension useofjunkdimension datawarehousejunkdimensi

1 Reply

Posts: 18

Admin

Aug 30, 2020 4:33 pm

(@vinodkrsetty5895)

Active Member

Joined: 4 years ago

Generally in the junk dimension, we keep cartesian products of all the attributes possible values.

creation of the junk dimension provides an easy way to access the dimensions from a single point of entry and improves the performance of SQL Query.

It also helps to keep the data warehouse design as simple and straight forward as that users will be able to access data easily.

Generally in the junk dimension, we keep cartesian products of all the attributes possible values.