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

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

Question Posted / dilip

2 Answers
7402 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

Briefly define a session task?

0 Answers

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers Bosch,

What are Target Options on the Servers?

1 Answers

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers Syntel,

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers IBM,

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers

How will u find weather dimension table is big in size of a fact table?