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 data types present in bo? What happens if we implement view in the designer n report?
What needs to be done when the database is shutdown?
What are diagrams?
Explain when do we analyze the tables? How do we do it?
What are partition points?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
How can we do data cleaning?
What is the very basic difference between data warehouse and operational databases?
Start a batches with in a batch?
What is the 4 + 1 view model as it relates to system modeling?
What are aggregate tables and aggregate fact tables?
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 a static and local variable?
Who needs data warehousing?
Ist the schema that a data warehouse system can implements.
