what is materialised view? why we use it in data warehousing?
Answer Posted / suman palisetty
Materialized Views are objects which have information that has been aggregated and summarized from source tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of hierarchies?
What is an olap designer?
What are the advantages of cognos?
what is power prompt in cognos ep7series?what is the use of this?
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.
How do you Parametermap variables in Quiries?
Explain the difference between powerplay transformer and power play reports?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate 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 hi, i am searching job in cognos and datastage, does any
can provide me the real time experieced scenerios and
questions related to cognos and datastage projects, so if
anyone provide me the documents related this can very
helpful to me, my mail id is tchiru01@yahoo.com What is Fullouterjoin? 1. We have been asked to add summary information to
sales reprasentatives performance report. The report needs
to be grouped by country and city to compare performance
between areas Also we need to include revenue totals for
each city and each country. how you create security to reports? Can you explain dynamic query mode? 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.