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
Explain the hierarchies level data warehousing.
What is cfapplication tag?
What is the function of etl when used in data warehousing?
What is conformed fact?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
explain about balanced dimension,
What are the different types of scd's used in data warehousing?
What are vaious etl tools in the market?
How to stop a batch?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
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
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is perform recovery?
What is surrogate key? Where we use it? Explain with examples.
