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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Why update strategy and union transformations are active? Explain with examples.
What is an aggregator transformation?
What is the maplet?
How do you update the records with or without using update strategy?
What all are steps in up gradation of Informatica server?
Explain sessions. Explain how batches are used to combine executions?
How to create the source and target database connections in server manager?
What are some examples of informatica etl programs?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What happens when a session fails and you click on recover?
What is the difference between stop and abort in informatica
Plz can any one say me how to get the informatica certification materials and dumps
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to create Target definition for flat files?