Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7806 Views
- TCS, I also Faced
- E-Mail Answers
Answer / chanti
A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data.
A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.
| Is This Answer Correct ? | 3 Yes | 0 No |
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What is Performance tuning in Informatica?
What aer the out put files that the informatica server creates during the session running?
How to do Integration testing in Informatica?
How to extract sap data using informatica? What is abap? What are idocs?
Can you copy the batches?
What are the mapping parameters and mapping variables?
What is aggregate cache in aggregator transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
What is sq transformation?
Teradata 
