What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
- 1 Answers
- 1010 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the various tools? Explain name a few?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain where do we use semi and non additive facts?
What is an OLAP (On-line Analytical processing) system?
Where the applications and where
Explain what is fact less fact table? Where you have used it in your project?
What is cfapplication tag?
Explain what is a cube in data warehousing concept?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain what is a view as it relates to system modeling?
Explain a mapping, session, worklet, workflow, mapplet?
how to find unique records in informatica level
Teradata 
