Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56020 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / navas
View:It is a sql query which is executed and populates
results each time when the particular view is accessed.When
we make a DML statement in view it will affect the original
data available in datebase table.
Materialized view:Materialized view is similar to a table
that exists in the table space.The resultsets are fetched
and populated in materialized view from various table when
a meterialixed view is created and will be availabe until
the view is refreshed.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
What is the use of transformation?
What do you mean incremental aggregation?
What is a rank transform?
Performance tuning( what you did in performance tuning)
Why do you use Mapping Parameter and mapping variable?
What is substr in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the popular informatica products?
What is domain and gateway node?
What does refresh system mean, and what are its distinctive choice?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a repository? And how to add it in an informatica client?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain your project of banking domian.
