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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is INFORMATICA TESTING process
Where do we use mapping variables in informatica?
What are mapplets? How is it different from a Reusable Transformation?
What is informatica etl tool?
what is the size of u r source(like file or table)?
Where can we find the throughput option in informatica?
Mention few power centre client applications with their basic purpose?
Tell me about MD5 functions in informatica
What is session task and command task?
Why update strategy and union transformations are active?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the use of source qualifier?
What are the tasks that can be performed using sq?
How can we store previous session logs?
