Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13228 Views
- I also Faced
- E-Mail Answers
Answer Posted / anju
materialized view can be used to precalculate the expensive
joins and aggregates prior to execution and the result is
stored in a table in database and can refer to it in
future. the adv of this is increse in performance.
view is nothing but an sql query stored. it will not store
data in tables
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Briefly define a session task?
What do you mean incremental aggregation?
Describe data concatenation?
How can a transformation be made reusable?
Explain load alternative records / rows into multiple targets - informatica
Enlist the tasks for which source qualifier transformation is used.
What is a passive transformation?
According to his methodology what all you need before you build a datawarehouse
What is a filter transformation and why it is an active one?
What are the guidelines to be followed while using union transformation?
What is the scenario which compels informatica server to reject files?
Can u generate reports in Informatica?
tell me 5 session failure in real time how can you solve that in your project?
What happens when a session fails and you click on recover?
What the difference is between a database, a data warehouse and a data mart?
