Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56134 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / roshan
apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is InformaticaPowerCenter?
What are the features of complex mapping?
Under which circumstances, informatica server creates reject files?
Can we create two repositories on same database instance in oracle?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Write the unconnected lookup syntax and how to return more than one column.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how many types of dimensions are available in informatica?
Can we override a native sql query within informatica?
define galaxy repository in informatica
What is domain and gateway node?
What do you understand by term role-playing dimension?
How would you join a node to the already existing domain?
r u done any partitions in ur project?
