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 the difference between a table and the materialized
view?

Answers were Sorted based on User's Feedback



What is the difference between a table and the materialized view?..

Answer / deepthi

1.Refreshing of data is possible in materialised views. we
can restrict rows of data for acces from other users in
materialised views.

above mentioned two points are not possible with table.

Thanks
Deepthi

Is This Answer Correct ?    6 Yes 0 No

What is the difference between a table and the materialized view?..

Answer / chandra

TABLE: A TABLE IS HAVING ALL THE COLUMS DATA

WHERE AS

MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the types of groups in Router transformation?

1 Answers   Informatica,


insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  


Different sorts of metadata that stores in the storage facility?

0 Answers  


How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  


My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,


How do you migrate data from one environment to another?

0 Answers  


What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  


why union transformation is active transformation?

6 Answers   IndiGo, TCS,


what transformations are used for Variable port?

2 Answers  


What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,


how many types of dimensions are available in informatica?

0 Answers  


Categories