Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhinaw prakash
When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.
Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.
Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explian the Process of deployment groups in informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is workflow monitor?
What is an expression transformation?
What is rank transformation in informatica
Explain sessions. Explain how batches are used to combine executions?
How many input parameters can exist in an unconnected lookup?
What is the sql query overwrite in source qualifier in informatica
Write the different tools in the workflow manager?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Clarify the aggregator change?
Clarify the utilization of aggregator cache record?
What are the different ways to implement parallel processing in informatica?
