Interested to Buy Any Domain ? << Click Here >> for more details...
What is the "junk dimension"? Give with examples?
- 8 Answers
- 19430 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shree uday
Junk dimension: A junk dimension is a collection of random
transactional codes, flags and/or text attributes that are
unrelated to any particular dimension. Simply to say a
randomly used dimension is junk dimension
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / pratap gangula
Junk dimension is a cartesan product of dimensions which have very low cardinality. So instead of making separate dimensions for each such low cardinality source, combine all of them into one single dimension. This saves the number of foreign keys on the fact table which reduces the number of indexes on fact tables. Eventually it increases the performance of the cube.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / madhoo
What shree uday said that is right and with that there is
one another thing we can say ........
i.e we can simply say which dimension is having low cardinality
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / poorna chandra reddy
A number of very small dimensions might be lumped together
to form a single dimension, a junk dimension - the
attributes are not closely related. Grouping of Random
flags and text Attributes in a dimension and moving them to
a separate sub dimension is known as junk dimension.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / arkchowdary
------------------Junk Dimension----------------------------
------------------ A 'Junk' dimension is a collection of
Random transactional codes,flags and/or text attributes
that unrelated to any perticular dimension.
----------------- Junk dimension is just a dimension that
stores unwanted attributes.
I hope it is clear.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / guest
------------------Junk Dimension----------------------------
------------------ A 'Junk' dimension is a collection of
Random transactional codes,flags and/or text attributes
that unrelated to any perticular dimension.
----------------- Junk dimension is just a dimension that
stores unwanted attributes.
I hope it is clear.
| Is This Answer Correct ? | 3 Yes | 2 No |
A junk dimention table is a collection of junk dimentioms.
The Dimentions which are not related to any fact tables is
known as ju;nk dimention.Generally it is used to provide
extra informations.
| Is This Answer Correct ? | 4 Yes | 3 No |
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is called data cleaning?
Explain the hierarchies level data warehousing.
Why null values are mapped as 0 in fact tables?
Why facts table is useful in representing the data?
What is difference between model & package?
Explain what is the difference between stop and abort?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
How to drill through from a powerplay cube to reportnet?
What is informatica architecture?
What is metadata in context of a datawarehouse?
How to load the time dimension?
Teradata 
