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
Name the types of report?
-----------With out using DrillThrough how to do Reports?
What you mean by drill across?
Define datastores in cognos?
What is main difference mapplets and mapping?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
How create measures and dimensions?
What is the difference b/w macros and prompt?
in u r data u having duplicates how to fetch the latest data in our report?
Can you define bitmap index?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is meant by alternate drill down with ex?
Is it possible to join multiple Databases in a Catalog?
what is a prompt value in report studio and variables ?
---------------Tell me about DWH Concepts?