Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 12885 Views
- I also Faced
- E-Mail Answers
Answer Posted / atiric sofrware(raja)
Views contains query whenever execute views it has read from
base table
Where as Materialised views loading or replicated takes
place only once which gives you better query performance
Refresh materialised views
1.on commit
2. on demand
(Complete, never, fast, force)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
How to update source definition?
Explain transaction control transformation in informatica
Make a note of the quantity vaults made in informatica?
How can we delete duplicate rows from flat files?
Sequence generator, when you move from develoment to production how will you reset
What are the types of data warehouses?
can u any challenge your project?
What is the difference between Active and Passive transformation?
What are 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?
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 ?
How we can create indexes after completing the load process?
How to extract the informatica rejected data?
What are the differences between oltp and olap?
What is a snowflake schema?
