Whatis the difference between View and Materialized View ?
Answer Posted / senthil
hi,
we already know basic restrictions of view and materialized
view,
view is a logical or virtual table it doesn't have data on
its own, but materialized view has a physical structure it
stores data in local machine or on its own.materialized view
can be refreshed automatically or manually. but in view, if
any changes happened in the base tables, we want to reflect
the same in the view means view has to issue the select
statement again to the database
| Is This Answer Correct ? | 71 Yes | 6 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
How do you load alternate records into different tables through mapping flow?
server hot-ws270 is connect to Repository B. What does it mean?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what is song in infrmatica...?
what are 3 tech challenges/ common issues you face?
Define filter transformation?
Explain the code page compatibility?
What are the new features of informatica 9.x developer?
What do you mean incremental aggregation?
Explain pushdown optimization and types in informatica
what are the deliverables?in your project?
What is olap (on-line analytical processing?
What is joiner change?