What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
- 1 Answers
- 1003 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ruchi Singh
A junk dimension (also known as a surrogate key dimension) is a dimension that consists of a single attribute, which is a unique identifier such as an auto-incrementing integer or universally unique identifier (UUID). Junk dimensions are used to associate multiple facts with the same set of attributes in a dimension table. This reduces data redundancy and improves query performance by allowing for faster joins between fact and dimension tables.
A degenerated dimension, on the other hand, is a dimension where one or more of its primary key attributes are non-descriptive (i.e., they do not describe the entities in the dimension) and are included solely to establish relationships with other tables. A degenerated dimension can be avoided by using a foreign key relationship between the fact table and another dimension table that contains meaningful, descriptive attributes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain how to generate iqd file from framework manager?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the purpose of Dataware Control?
