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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dilip

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

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

what is mean by flag 4 in update strategy t/r

6 Answers  

without table how to come first record only in oracle?

0 Answers  

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

Explain lookup transformation source types in informatica

0 Answers   Informatica,

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  

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

what happens when a batch fails?

3 Answers  

generate date / time dimension in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories