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
what is index?how it can work in informatica
tell me the rules and responsblites in our project(my project is development)
how we can load rejected record's at run time?(not through bad files)
how tokens will generate?
What are data-driven sessions?
What are the various types of transformation?
What can we do to improve the performance of informatica aggregator transformation?
What are the different types of repositories created using informatica?
What is an unconnected transformation?
How would you copy the content of one repository to another repository?
What do think which one is the better joiner or look up?
What is sorter transformation?
What are the tuning techniques you applied during your last project
How can we improve session performance in aggregator transformation?
Can we create multiple integration service on single repository?