What is the "junk dimension"? Give with examples?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are non-additive facts in detail?

584


Explain what are the modules in power mart?

566


What is a full backup?

538


How to test report in reportnet?

563


What are the data marts?

524






What is meant by metadata in context of a data warehouse and how it is important?

652


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

513


Explain what are the different types of data warehousing?

512


Explain how are the dimension tables designed?

560


Suggest a good author for hyperion in data warehousing?

556


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

1726


What are the difference between snow flake and star schema?

509


Explain what is the main difference between inmon and kimball philosophies of data warehousing?

523


How to reduce warnings?

524


What is surrogate key? Where we use it? Explain with examples.

542