Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialized view?
- 2 Answers
- 5013 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mike
Well in simple terms
A meterialized view is a view that contains data in some
temporary tables. If we consider the view at database level
it only stores the query , when ever we call the view it
extracts the data from the database based on the query...
| Is This Answer Correct ? | 0 Yes | 0 No |
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
In a concurrent batch if a session fails, can you start again from that session
What are active and passive transformations?
what is $$$$?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Can we override a native sql query within informatica?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
how can we load starting with 11th record of a table from source to target
How will you display "Mr" for male & "Mrs" for female in target table?
How you know when to use a static cache and dynamic cache in lookup transformation?
How can you run a session without using server manager?
Teradata 
