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...

Whatis the difference between View and Materialized View ?

Answer Posted / roshan

apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...

Is This Answer Correct ?    13 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is index?how it can work in informatica

2081


tell me the rules and responsblites in our project(my project is development)

1974


how we can load rejected record's at run time?(not through bad files)

2422


how tokens will generate?

2245


What are data-driven sessions?

1255


What are the various types of transformation?

1238


What can we do to improve the performance of informatica aggregator transformation?

1139


What are the different types of repositories created using informatica?

1168


What is an unconnected transformation?

1125


How would you copy the content of one repository to another repository?

1058


What do think which one is the better joiner or look up?

1240


What is sorter transformation?

1106


What are the tuning techniques you applied during your last project

2071


How can we improve session performance in aggregator transformation?

1149


Can we create multiple integration service on single repository?

1237