Interested to Buy Any Domain ? << Click Here >> for more details...
when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 10013 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satya/gunu(satyabadi)
=>
-Star schema is highly denormalized.
-Snowflake schema is normalized.
=>
-As star schema is denormalized, the size of DWH will be larger than that of Snowflake schema.
=>
-Performance wise, star schema is good.
-But if memory utilization is a major concern,then snow flake schema is better than star schema.
=>.. In addition, Generally in real time, we use Snowflake schema only.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What are the main services provided by application tier?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What are all the advantages of Cognos?
Explain what is the difference between native sql and cognos sql?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Explain the characteristics of cognos?
what is power prompt in cognos ep7series?what is the use of this?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
9. What was the most complex type of report you dealt with?
2. What functional area you worked on.
What is Fullouterjoin?
----------------Describe DWH Architecture?
What is the difference between static and dynamic conditions?
