why we use materialized view over view?
- 1 Answers
- 4457 Views
- Zensar, I also Faced
- E-Mail Answers
Answer / 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 |
How do you set a varible in incremental aggregation
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
how to connect two or more table with single source qualifier?
How to read data from flat file source if the data is in paragraph format?
What is the session task and command task?
what is DSS?
what is mean by throghput? in informatica
Where are the source flat files kept before running the session?
How can we update a record in the target table without using update strategy?
What is the difference between view and materialised view?
how to create a sample mapping for dynamic lookup transformation
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Teradata 
