Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do we call shell scripts from informatica?
How do you set a varible in incremental aggregation
How can you validate all mappings in the repository simultaneously?
How we can create indexes after completing the loan process?
Explain the different lookup methods used in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What's the layout of parameter file (what does a parameter file contain?)?
How to generate sequence numbers?
How union transformation is used?
What is the function of union transformation?
What is primary and backup node?
can u give example for factless fact table
Performance tuning( what you did in performance tuning)
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
