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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Is it possible to define a single node as a Gateway node as well as worker node?
Which version configuration tool used in ur project?
What are the main issues while working with flat files as source and as targets ?
Explain the different lookup methods used in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can we override a native sql query within informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
without table how to come first record only in oracle?
What is an Integration service in Informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How do you change a non-reusable transformation to reusable transformation?
Why update strategy and union transformations are active?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Enterprise data warehouse your projects phase by phase explain?
