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

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

What is the target load order?

3 Answers   HCL, Informatica,

How informatica recognizes mapping?

2 Answers   CTS,

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

What are the different tools in workflow manager?

1 Answers  

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

In how many ways we can create ports?

0 Answers  

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

What is meta data and system catalog?

2 Answers  

For more Informatica Interview Questions Click Here
Categories