when can i use the STAR Schema and SNOWFLAKE Scgena
Answer Posted / saptashaw
Star is better for performance.
Snowflake happens when one or more dimension tables in the
Star are normalized. This is done when there is sparsity in
the concerned dimensions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is a Datastore in Cognos?
Write types of folders present in cognos?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Cleared COG-112 with 100% score today. What next certification should i go for?
What are the types of security?
----------------Describe DWH Architecture?
Why is auto-regression used in forecasting used on cognos platform?
what is model and say about process how to create model and how to test model?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
How do you improve the performance of the Cognos Analytics report
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What are the roles defined by cognos platform?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days