what is materialized view?
- 2 Answers
- 4574 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 |
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
How to load a relational source into file taget?
Explain in detail scd type 2 through mapping.
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
Explain how many types of dimensions are available in informatica?
How to fix the etl bugs..Tell me the process?
Do you have knowledge in ralph kimball methodology
what are the challenge face in u r project?explain me
What is meant by target load plan?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
Name at least 5 different types of transformations used in mapping design and state the use of each.?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
Teradata 
