What is the difference between view and materialised view?
- 4 Answers
- 11739 Views
- I also Faced
- E-Mail Answers
Answer Posted / sindhu
View - store the SQL statement in the database and let you
use it as a table. Every time you access the view, the SQL
statement executes.
Materialized view - stores the results of the SQL in table
form in the database. SQL statement only executes once and
after that every time you run the query, the stored result
set is used. Pros include quick query results
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
How to elaborate powercenter integration service?
Explain the etl program with few examples.
scenario where i can use only concurrent execution of workflow.
Is there any way to read the ms excel datas directly into informatica?
wf dont have integration severances how you can run?
How to update or delete the rows in a target, which do not have key fields?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Different circumstance which drives informatica server to expel records?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what is unit testing?tell me proceedure
Is it possible to revert a global repository to local one and why?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
