Answer Posted / shruthi
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
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.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
where to store informatica rejected data? How to extract the informatica rejected data?
what is informatica metadata?
What is Session and Batches?
What are the components of Informatica? And what is the purpose of each?
What are the advantages of informatica?
How can we handle two sessions in informatica?
What are the designer tools for creating transformations?
How identifying bottlenecks in various components of informatica and resolving them?
How can you differentiate between powercenter and power map?
What could be the possible resons of locks by user?
Clarify the aggregator change?
What is a surrogate key?
Parameter and variable differences
Briefly define a session task?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
