Whatis the difference between View and Materialized View ?
Answer Posted / surajit n bhowmick
A View is just a stored query and has no physical role.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache.
A materialized view has a physical table associated with
it, it does not have to resolve the query each time it is
queried. Depending on how large the result and how complex
the query, a materialized view should perform better.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
Can we create a Integration service without a Repository service and vice versa?
how to load rows into fact table in data warehouse
How can informatica be used for an organization?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is repository manager?
What is the difference between source qualifier transformations source filter to filter transformation?
What is meant by target load plan?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a code page?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is event and what are the tasks related to it?
What is dimensional table? Explain the different dimensions.
Enlist the various types of transformations.