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 are the steps to build the datawarehouse?
Explain dimension table ?
What is the difference between static cache and dynamic cache?
Explain bus schema?
What is normalization, first normal form, second normal form, third normal form?
Where the cache files stored?
What are the reasons to use a chameleon method in data warehousing?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Why facts table is useful in representing the data?
How to create diff. Types of templates?
Explain a mapping, session, worklet, workflow, mapplet?
Tell me what is degree of a relation?
What is metadata in context of a datawarehouse and how it is important?
What are the advantages and disadvantages of reporting directly against the database?
