In view we cannot do DML commands where as it is possible in Materialized

Whatis the difference between View and Materialized View ?

Question Posted / guest

Answer Posted / guest

In view we cannot do DML commands where as it is possible
in Materialized view.

Is This Answer Correct ?

39 Yes

121 No

Please Help Members By Posting Answers For Below Questions

can we override a native sql query within informatica? How do we do it?

1121

What does refresh system mean, and what are its distinctive choice?

1163

What is flashback table ? Advance thanks

1928

What is an aggregator transformation?

1096

What are the advantages of informatica?

1006

What is rank transform?

991

What is exclusive and normal mode for repository services?

1138

what is unit testing?tell me proceedure

2219

What is enterprise data warehousing?

1045

Clarify the utilization of aggregator cache record?

990

Quickly characterize reusable change?

1114

Do you find any difficulty while working with flat files as source and target?

1092

How to elaborate powercenter integration service?

1127

How to update a particular record in target with out running whole workflow?

1572

Reusable transformation and shortcut differences

1838