What is the difference between view and materialised view?
Answer Posted / deepika
a view is like window through which we can acess the data.
it doesnot store the data,where as materialized view can
contain data also.this can be used for pre computed complex
calulations.
materialized views are called snapshots before oracle 9i
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
explain one complex mapping with logic? sales project?
What is the fact table?
How union transformation is used?
What are pre and post-session shell commands?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to create the source and target database connections in server manager?
How would you copy the content of one repository to another repository?
Differences between version 7.x and 8.x.
What are the components of workflow manager?
What is informatica powercenter repository?
list out all the transformations which use cache?
What is expression transformation?
What is the different lookup cache(s)?
can u any challenge your project?