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 real-time data warehouse?
What is the difference between er modeling and dimensional modeling?
After the complete generation of a report who will test the report and who will analyze it?
How can we do data cleaning?
What is called data cleaning?
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.
What is index awareness in universe?
Explain what is a view as it relates to system modeling?
What is core dimension?
Explain the difference between keylokup and joiner?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
if you use oracle sql*loader , how do you transform data with it during loading?
What is batch processing?
Explain me what are data marts?
Explain what are the steps to build the data warehouse?
