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 the difference between filter and lookup transformation?
Where the applications and where ware house management system is used?
Why is chameleon method used in data warehouse?
What is Discover and Execute in XMLA?
What is real-time datawarehousing?
Explain differences between star and snowflake schemas?
How to calculate fact table granularity?
Define data warehouse?
Explain what is the difference between power center & power mart?
Difference between cold fusion mx 6 and cold fusion mx 7?
Why fact table is in a normal form?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
How can we determine what records to extract?
Explain what are the mapping paramaters and maping variables?
What are the advantages of cold fusion?
