Forum

Notifications
Clear all

What is Junk Dimension in Data Warehousing?


Deepak Raj
Posts: 18
 Deepak Raj
Topic starter
(@Deepak Raj)
Joined: 1 year ago

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

1 Reply
VK
Posts: 17
 VK
(@vinodkrsetty5895)
Active Member
Joined: 1 year 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.

Reply
Share: