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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to build the datawarehouse?

581


what are the all possible features supported modify stage?

1609


Explain what are the various reporting tools in the market?

555


how much memory space occupied real time project (roughly)?

1801


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

545






What are non-additive facts in detail?

528


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

534


Code the tables statement to produce a multi-level frequency?

544


What are steps we have to follow in designing the userfriendly universe?

550


What is a general purpose scheduling tool?

553


What is conformed fact?

626


What are cluster analysis in data warehousing?

558


What is the difference between snowflake and star schema?

583


Compare aggregates and data marts

2275


What is the use of incremental aggregation? Explain me in brief with an example?

581