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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5262


What is drill-through?

572


Explain piconet?

548


What is the main difference between schema in rdbms and schemas in datawarehouse?

539


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

550






Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

1679


What is the difference between view filter and report filter?

511


Explain what are conformed dimensions?

566


What are the various tools? Explain name a few?

536


Give some difference between oltp and olap.

592


Explain which columns go to the fact table and which columns go the dimension table?

520


What is freehand sql?

603


For faster process, what we will do with the universe?

568


What is fact less fact table? Where you have used it in your project?

507


What are the different types of scd's used in data warehousing?

581