Whatis the difference between View and Materialized View ?
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
Under what condition selecting sorted input in aggregator may fail the session?
What are session parameters ? How do you set them?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How might you approve all mappings in the archive all the while?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How would you copy the content of one repository to another repository?
What are roles and groups and benefits of using them?
generate date / time dimension in informatica
What are the reusable transformations?
Explain how many types of dimensions are available in informatica?
Explain the code page compatibility?
Explain lookup transformation source types in informatica
What are the features of complex mapping?
How to load a Dimension ? and how to load a fact table?
What is the commit type if you have a transaction control transformation in the mapping?