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
What is the difference between snowflake and star schema?
What is cfapplication tag?
What is VLDB?
What is a real-time data warehouse?
Can we take backup when the database is opened?
What we will do with the universe for faster process?
Which columns go to the fact table and which columns go the dimension table?
Why is dimensional normalization not required?
Explain hybrid slowly changing dimension?
Explain what are the various file formats involved in reportnet?
What are the steps of implementing data warehousing?
Is there any rownum object from which we can do this?
Explain difference between data ware house & data mart?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain what is the advantages data mining over traditional approaches?
