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
Explain transaction control transformation in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the mapping parameters and mapping variables?
Briefly describe lookup transformation?
In development project what is the process to follow for an etl developer from day1
How to generate or load values in to the target table based on a column value using informatica etl tool.
Differences between version 7.x and 8.x.
How to create a non-reusable instance of reusable transformations?
What is meant by incremental aggregation?
Differentiate between joiner and lookup transformation?
What is the status code in stored procedure transformation?
Define the various join types of joiner transformation?
To import the flat file definition into the designer where should the flat file be placed?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the difference between router and filter?
