What is the difference between view and materialised view?
Answer Posted / sarvesh
VIEW IS THE VIRTTUAL TABLE,AND WE CANOT REFRESH THE
DATA ,BUT IN MATERIALISED VIEW WE CAN REFRESH THE DATA
FREQUNENTLY,AND BY USING M.VIEW THE PERFORMANCE WILL BE
INCREASED.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How many types of sessions are there in informatica.please explain them?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the differences between joiner transformation and source qualifier transformation?
what is size of u r database?
What is pmcmd command?
How to create the source and target database connections in server manager?
What do you understand by a term domain?
what is SDLC way of code development?
How to differentiate between the active and passive transformations?
What is blocking transformation?
Explain how to import oracle sequence into informatica?
What is data movement mode in Informatica and difference between them?
What are the different transaction levels available in transaction control transformation?
What are the new features of informatica 9.x at the developer level?
What is complex mapping?