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

what is incremental data aggregation?

3 Answers   IBM,

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

Which is the t/r that builts only single cache memory?

0 Answers  

why we use datawarehouse

0 Answers   HCL,

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

What are the reusable transforamtions?

2 Answers  

Why union transformation is an active transformation?

0 Answers   Informatica,

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

What are the tasks that Loadmanger process will do?

1 Answers  

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

For more Informatica Interview Questions Click Here
Categories