Interested to Buy Any Domain ? << Click Here >> for more details...
Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
- 2 Answers
- 8280 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / aq
Because, we use Star schema to analyse the data and for that we need fast access of that data.
if the schema is normalized then it will have more joins and will take more time retrieve the data from source, which will cause the reporting / analysis slow.
Hence to faster access of the data Star Schema is de-normalized
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Define metrics studio?
9. What was the most complex type of report you dealt with?
New coloums are added in database, then how you know in report level
Mention the difference between ‘macros’ and ‘prompt’?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
write a query to display the departments with no employee?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Write types of folders present in cognos?
Can you define report item?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
what is the difference between filter and condition?
which type of project we r going to snowflake schema
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
