Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
- 2 Answers
- 7123 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
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is the difference between a cascading report and drill through report?
What are the advantages of shortcuts?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what is the role of cognos comsultant?what actually it means?pls reply
-----------------What is Determination Model?
what is the difference between filter and condition?
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
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
is cognos 7 is better than cognos 8
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is catalog and types of catalogs in cagonos and which is better?
What are the different types of important services used in cognos?
