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
How are models actually derived?
In document how to create metrics?
What is the function of surrogate key in data warehousing?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain the difference between data ware house & data mart?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
what are different storage options supported by oracle ?
What is the difference between view materialized view and view?
What are universe requirements?
What is data type of the surrogate key?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is a general purpose scheduling tool?
Explain datawarehousing?
What is the difference between ods and oltp?
What are loops in Datawarehousing?