Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is materialised view? why we use it in data warehousing?

Answer Posted / ram

Materialised view will stores the results of sql in the tables form in the database. materialised view contains data physically.view doesn't contain data physically.materialised view will be updated with batch upted know as refreshes.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write a query to display the departments with no employee?

1950


What are shortcuts? Where it can be used? What are the advantages?

1047


What is called cognos reporting tool?

1038


difference between impromptu and cognos8

2416


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.

2184


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2408


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2291


can we insert all types of charts in a list report? what r the realtime prompts?

2195


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.

2069


What are the methods by which it non-durable model could be changed into the durable model?

939


how u will determine the performence tune will occur either in report or system

2121


What is difference between page break and section report?

1196


What is zero-foot print?

1004


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.

1995


how to explain health care project and which reports we can create in health care doain?

6778