Interested to Buy Any Domain ? << Click Here >> for more details...
What is the "junk dimension"? Give with examples?
- 8 Answers
- 19871 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 Time Series algorithm in data mining?
what is the difference between etl tool and olap tools
Disply the dname wise maximum salary
What is the difference between constraind base load ordering and target load plan?
Explain why denormalization is promoted in universe designing?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What are the stages that are required in data warehousing?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Explain multivalued dependency?
What are the steps involved in creating dimensional modeling process?
Explain the difference between data ware house & data mart?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Teradata 
