Whatis the difference between View and Materialized View ?
- 11 Answers
- 53078 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / manohara reddy
view is logic and virtual table. it does't hold data.it
allows DML Operations.when ever u update or insert in base
table or view automatically changed those.
materialized view is static. u want create m.view DBA
Privileges and permissions must. it hold data all. when ever
u update or create rows in base table , it update only
update base table. doesn't change.
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is xml source qualifier transformation in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Enlist some properties of sessions.
Name the different lookup cache(s)?
What can we do to improve the performance of informatica aggregator transformation?
In development project what is the process to follow for an etl developer from day1
What is native users?
my source is junk data how will u remove that junk data by using unix please any one replay me
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Informatica settings are available in which file?
How can we delete duplicate rows from flat files?
update strategy transformation in informatica
What is a grid in Informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is workflow? What are the components of the workflow manager?
