Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14360 Views
- I also Faced
- E-Mail Answers
Answer Posted / anurag arun edlabadkar
Difference Between Inline View & Materialized View?
You can use Materialized views to pre-aggregate the data
and improve the query performance. When you create a
materialized view, Oracle created a physical table to hold
data that would usually be read via a view. When you create
a materialized view, you specify the view's base query as
well as a schedule for the refreshes of its data. You can
then index the materialized view to enhance the performance
of queries against it. As a result, you can provide data to
your user in the format they need, indexed appropriately.
A View is a database object that is a logical
Representation of of a table. It is derived from a table
but has no storage of its own and often may be used in the
same manner as a table.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is meant by incremental aggregation?
What is decode in static cache?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to update a particular record in target with out running whole workflow?
Which version configuration tool used in ur project?
Is it possible to revert a global repository to local one and why?
What are the differences between joiner transformation and source qualifier transformation?
How might one distinguish in the case of mapping is right or not without associating session?
Enlist some properties of sessions.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Write the unconnected lookup syntax and how to return more than one column.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a joiner transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is lookup transformation?
