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
Why facts table is useful in representing the data?
What is called data cleaning?
What are the different types of data warehouses?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
how much memory space occupied real time project (roughly)?
Explain what is data validation strategies for data mart validation after loading process?
What is the difference between power center and power mart?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the differences between star and snowflake schema?
After the complete generation of a report who will test the report and who will analyze it?
How can we run the graph? How can we schedule the graph in unix?
What are the various methods of getting incremental records or delta records from the source systems?
Explain bus schema?
What is a real-time data warehouse?
