Interested to Buy Any Domain ? << Click Here >> for more details...
What is the "junk dimension"? Give with examples?
- 8 Answers
- 19686 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 are different stages of ?Data mining??
What is called data cleaning?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
waht is the advantage of infoset query
Explain swot analysis?
Best institute for MS BI training in Hyderabad, India?
What are the methodologies of data warehousing?
What is Snow Flake Schema design in database?
What are various warehousing tools?
What is the difference between a primary and secondary actor in use case modeling?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What is a Data Warehouse?
Teradata 
