Interested to Buy Any Domain ? << Click Here >> for more details...
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 difference between source qualifier transformations source filter to filter transformation?
What is an aggregator transformation?
Can we override a native sql query within informatica?
How do you load unique records into one target table and duplicate records into a different target table?
What are the types of data warehouses?
How can you generate reports in informatica?
What is the use of source qualifier?
What is a joiner transformation and why it is an active one?
What are the differences between a connected lookup and unconnected lookup?
What is parallel processing in informatica?
What are the measure objects?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Differentiate between sessions and batches?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are connected or unconnected transformations?
