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
What is the function of aggregator transformation?
scenario where i can use only concurrent execution of workflow.
Which are the different editions of informatica powercenter that are available?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Differentiate between sessions and batches?
What is joiner transformation in informatica?
What are the different types of repositories created using informatica?
How to create a non-reusable instance of reusable transformations?
Could you explain what is enterprise data warehouse?
What are the differences between source qualifier and joiner transformation?
What is a surrogate key?
What are the different ways to implement parallel processing in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the Rank index port in Rank transformation?
What is the difference between informatica 7.0 and 8.0?
