Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13069 Views
- I also Faced
- E-Mail Answers
Answer Posted / sindhu
View - store the SQL statement in the database and let you
use it as a table. Every time you access the view, the SQL
statement executes.
Materialized view - stores the results of the SQL in table
form in the database. SQL statement only executes once and
after that every time you run the query, the stored result
set is used. Pros include quick query results
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the advantage of informatica?
Explain what are the different versions of informatica?
Design a mapping to load a target table with the following values from the above source?
What are the types of caches in lookup?
What are the new features of informatica 9.x in developer level?
What is dimensional table? Explain the different dimensions.
What is the scenario which compels informatica server to reject files?
How to do unit testing in informatica?
What is the difference between informatica 7.0 and 8.0?
Briefly define reusable transformation?
differences between service based and product based?
What is aggregate cache in aggregator transformation?
what is size of u r database?
