Interested to Buy Any Domain ? << Click Here >> for more details...
What is the "junk dimension"? Give with examples?
- 8 Answers
- 19688 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 |
What is data stream and data adaopter. Is it same are different? Explain?
Explain how many ways you create ports?
Explain vldb?
What is analytical or analytic mean?
in general which algorithms for used?
Explain about core dimension, balanced dimension, and dirty dimension?
What are different deliverables according to phases?
Can you brief about the Data warehouse project you worked on?
What is the difference between drill through and masterdetail reports?
Explain Association algorithm in Data mining?
What is the goal of optimizer?
Do you view contain data?
Teradata 
