Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pratap gangula
Junk dimension is a cartesan product of dimensions which have very low cardinality. So instead of making separate dimensions for each such low cardinality source, combine all of them into one single dimension. This saves the number of foreign keys on the fact table which reduces the number of indexes on fact tables. Eventually it increases the performance of the cube.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Where the applications and where ware house management system is used?
What is surrogate key? Explain with examples.
What are loops in Datawarehousing?
What is "method/1"?
Explain what are the advantages of query studio compared to report studio?
What is the difference between view materialized view and view?
What is the difference between agglomerative and divisive hierarchical clustering?
Explain datawarehousing?
What is vldb(very large databases)?
Explain what are the methodologies of data warehousing?
What is cubes?
What is operational data store (ods)?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Is there any default username & pwd for bo designer & supervisor?
