Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56445 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / manohara reddy
view is logic and virtual table. it does't hold data.it
allows DML Operations.when ever u update or insert in base
table or view automatically changed those.
materialized view is static. u want create m.view DBA
Privileges and permissions must. it hold data all. when ever
u update or create rows in base table , it update only
update base table. doesn't change.
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
Explain the different kinds of facts.
Can you generate sequence numbers without using the sequence generator transformation?
Please let me know how to make encryption and decryption with example?
Enlist few areas or real-time situations where informatica is required.
What is the Rank index port in Rank transformation?
What are the types of caches in lookup? Explain them.
expain about the tune parameters?
What is lookup change?
How we can use union transformation?
What is the benefit of session partitioning?
how many types of dimensions are available in informatica?
What is the difference between source qualifier transformations source filter to filter transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the different lookup cache(s)?
What are the new features of informatica 9.x at the developer level?
