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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a joiner transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
generate date / time dimension in informatica
What is domain and gateway node?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are ETL Tools?
What are the static cache and dynamic cache in informatica?
What are the new features of informatica 9.x in developer level?
Differentiate between joiner and lookup transformation?
Separate from an archive server and a powerhouse?
What is the cumulative sum and moving sum?
What is dynamic cache?
What could be the possible resons of locks by user?
what is INFORMATICA TESTING process