Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / banjwolf
A junk dimension is a table containing all known or given
combinations of two or more other dimensions. It is then
used as a lookup from a fact table to find the combination
of dimensions that relate to that fact. The purpose is to
declutter and reduce the width of the fact table.
An example might be a [SalesFact] table which references a
junk dimension [SalesExtentionDIM] containing values/SKs
for dimensions of [OnSaleYN] , [SaleCodeSK] , [ColourSK] ,
[baggedYN]
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a source qualifier?
Explain what is the difference between olap and datawarehosue?
How many types of facts and what are they?
What are the differences between star and snowflake schema?
What is hybrid slowly changing dimension?
Explain what is cost benefit analysis (cba)?
What is the metadata extension?
What is data stream and data adaopter?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are algorithms provided by Microsoft in SQL Server?
How can you communicate with web server (apache or iis) from coldfusion?
What are templates in which way it is help full?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How do you define data block size?
How to add a number to a macro variable?
