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
What are the different types of transformation available in informatica.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the benefit of session partitioning?
How can a transformation be made reusable?
what are 3 tech challenges/ common issues you face?
Explain what are the different types of transformation available in informatica.
wf dont have integration severances how you can run?
Explain transaction control transformation in informatica
How to use procedural logic inside infromatica?
Differentiate between a database and data warehouse?
what is diff b/t sorter t/r and agg have the option sorter property...
What is dynamic cache?
How can we improve session performance in aggregator transformation?
What are the transformations that are not supported in mapplet?
