When we issue Select * from View it'll fetch the data from the Base t

why we use materialized view over view?

Question Posted / abhinaw prakash

1 Answers
5290 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / abhinaw prakash

When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.

Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.

Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a difference between complete, stop and abort?

1078

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1044

What is DR strategy for Informatica project?

1169

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1950

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1261

in reporting we add some new objects,how we get the count of the newly added objects to the report

2189

How can you differentiate between powercenter and power map?

1084

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2718

What are the differences between a connected lookup and unconnected lookup?

1065

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1993

What is a passive transformation?

1099

What is an Integration service in Informatica?

1128

Explain the code page compatibility?

1057

Explain joiner transformation in informatica

1123

How to create a non-reusable instance of reusable transformations?

1115