Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13225 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 shared cache and re-cache?
what is degenerated dimension?
What are active and passive transformations?
What is the commit type if you have a transaction control transformation in the mapping?
What is data movement mode in Informatica and difference between them?
How can you validate all mappings in the repository simultaneously?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Can we create a node as a gateway node and the same node can be assigned to a grid?
Where do we use mapping variables in informatica?
How can you increase the performance in joiner transformation?
Explain incremental aggregation in informatica
What is a repository? And how to add it in an informatica client?
What are the restrictions of union transformation?
