Interested to Buy Any Domain ? << Click Here >> for more details...
What is the "junk dimension"? Give with examples?
- 8 Answers
- 19414 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 the vaious etl tools in the market?
What is the difference between constraind base load ordering and target load plan?
How can you set the client management?
5.Explain ODS ?
What is data cleaning? How can we do that?
what is parallelism?
What is defined as partial backup?
Explain which are the olap tools available that are supported by oracle?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
I need to set predefined condition. How I do this?
What is called data cleaning?
What is data warehouse architecture?
Teradata 
