Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13011 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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the uses of etl tools?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Different circumstance which drives informatica server to expel records?
Sequence generator, when you move from develoment to production how will you reset
difference between repository database and repository service?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the prerequisite tasks to achieve the session partition?
How can we use batches?
what is mean by complex business rule ?
What are the new features of informatica 9.x at the developer level?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Differentiate between Load Manager and DTM?
In warehouses how many schemas are there?
is it possible to index the data in cache of lkp transformation ?
