What is the difference between view and materialised view?
- 4 Answers
- 11737 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
Reusable transformation and shortcut differences
How many ways a relational source definition can be updated and what are they?
What is primary and backup node?
generate date / time dimension in informatica
Briefly define reusable transformation?
Enlist few areas or real-time situations where informatica is required.
How can we use batches?
What is informatica?
Which is the t/r that builts only single cache memory?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain the types of lookup transformation?
In informatica workflow manager, how many repositories can be created?
can u any challenge your project?
How to differentiate between the active and passive transformations?
What is an expression transformation in informatica?
