Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56356 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
What is substr in informatica?
What is difference between a gateway node and worker node?
What is a surrogate key?
What do you mean by channel change?
How do you convert single row from source into three rows into target?
How to use pmcmd utility command?
What is the difference between a connected look up and unconnected lookup?
What is informatica metadata and where is it stored?
What is depict expression change?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
In how many ways we can create ports?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is rank transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
