Materialized View caches the data,but view cannt store the data all.

Whatis the difference between View and Materialized View ?

Question Posted / papa

Answer Posted / papa

Materialized View caches the data,but view cannt store the
data all.

Is This Answer Correct ?

27 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is fact table? Explain the different kinds of facts.

1078

What does command task mean?

1155

What is sequence generator transformation in informatica?

1081

What is the meaning of up gradation of repository?

1994

what is size of u r database?

2311

State the differences between sql override and lookup override?

1210

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2725

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

Could you explain what is enterprise data warehouse?

1148

What is meant by a domain?

1130

Differences between connected and unconnected lookup?

1222

scenario where i can use only concurrent execution of workflow.

3175

How to start a workflow using pmcmd command?

1256

design of staging area?

2030

What is an expression transformation in informatica?

1041