What is the difference between a table and the materialized
view?
Answer Posted / deepthi
1.Refreshing of data is possible in materialised views. we
can restrict rows of data for acces from other users in
materialised views.
above mentioned two points are not possible with table.
Thanks
Deepthi
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is a transaction control transformation?
What is the scenario which compels informatica server to reject files?
What is mapplet in informatica?
Which version configuration tool used in ur project?
How to update or delete the rows in a target, which do not have key fields?
What is the meaning of decode in informatica?
What are the transformations that are not supported in mapplet?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Clarify the aggregator change?
What is union transformation in informatica?
What is target designer and target load order?
What's the layout of parameter file (what does a parameter file contain?)?
Is stop and abort are same in informatica?
What are active and passive transformations?
what is the hint? how to use it to reduce the query processing in program?