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
What does “tail –f” command do and what is its use as an Informatica admin.
What are connected or unconnected transformations?
have u done any performance tuning? how u ll do?
Name the different lookup cache(s)?
Explain transaction control transformation in informatica
What is domain and gateway node?
What is an aggregator transformation?
What is data transformation manager process?
In warehouses how many schemas are there?
explain abt ur project architecture?
What is decode in informatica?
What are multi-group transformations?
What is a connected transformation?
Design a mapping to load a target table with the following values from the above source?
What is the difference between STOP and ABORT options in Workflow Monitor?