Forum

Share:
Notifications
Clear all

What is Junk Dimension in Data Warehousing?


Deepak Raj
Posts: 18
 Deepak Raj
Topic starter
(@Deepak Raj)
Joined: 2 years ago

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

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

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: