Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56392 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / navas
View:It is a sql query which is executed and populates
results each time when the particular view is accessed.When
we make a DML statement in view it will affect the original
data available in datebase table.
Materialized view:Materialized view is similar to a table
that exists in the table space.The resultsets are fetched
and populated in materialized view from various table when
a meterialixed view is created and will be availabe until
the view is refreshed.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
Explain the shared cache and re-cache?
What is option by which we can run all the sessions in a batch simultaneously?
State the differences between sql override and lookup override?
Under which circumstances, informatica server creates reject files?
Is there any target staging area in informatica not staging area
What is the difference between writing a joiner query in ANSI style and THETA style?
What is fact table? Explain the different kinds of facts.
What is InformaticaPowerCenter?
difference between informatica 8.1.1 and 8.6
What is lookup change?
What is a pre-defined event and user-defined event?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is dynamic cache?
