Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is option by which we can run all the sessions in a batch simultaneously?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What do you understand by SOA of Informatica?
how many types of dimensions are available in informatica?
How we can create indexes after completing the loan process?
What is an active transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is informatica powercenter repository?
without table how to come first record only in oracle?
Is there any target staging area in informatica not staging area
How to generate sequence numbers without using the sequence generator transformation?
Differentiate between Load Manager and DTM?
Define sessions in informatica etl?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Clarify the utilization of aggregator cache record?
