Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
- 2 Answers
- 7553 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
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
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 function of cognos dispatcher?
How to do Performence Tunning in Cognos Reports?
7. What is performance tuning?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
Which studio is used to create reports?
What are the types of studio present in Cognos?
How create measures and demensions?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
what is the difference between querystudio in reportnet and cognos8
Please explain the different stages in creating a report in cognos report net?
Explain informatica architecture?
What is metric store database?
