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 would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
List any five applications of data warehouse.
What is "method/1"?
Why is chameleon method used in data warehouse?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain why fact table is in normal form?
What is many-to-many dimensional model in datawarehousing ?
Who needs data warehousing?
Explain multivalued dependency?
What is the goal of optimizer?
Can we have multiple application.cfm file in an application?
explain about balanced dimension,
What are the methodologies of data warehousing?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is is a star schema?
