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 a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

How the Informatica Server reads perameter file?

1 Answers  

What are the different ways to implement parallel processing in informatica?

0 Answers  

connected and unconnected lookups?

4 Answers  

What are the data movement modes in informatica?

0 Answers   Informatica,

How can you differentiate between powercenter and power map?

0 Answers  

Which are the different editions of informatica powercenter that are available?

0 Answers  

What is the difference between Normal load and Bulk load?

5 Answers  

What is confirmed dimension?

3 Answers  

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

how to get the only updated records in the target

2 Answers  

For more Informatica Interview Questions Click Here
Categories