Whatis the difference between View and Materialized View ?
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
How does the aggregator transformation handle null values?
Can we get 1st record through Informatica(without sequence number).
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
is it possible to index the data in cache of lkp transformation ?
What is informatica etl tool?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to elaborate tracing level?
Explain the use of aggregator cache file?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the program through which the records can be updated?
What is domain and gateway node?
differences between service based and product based?
What is target designer and target load order?
What is informatica metadata and where is it stored?
What is option by which we can run all the sessions in a batch simultaneously?