Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 12873 Views
- I also Faced
- E-Mail Answers
Answer Posted / sindhu
View - store the SQL statement in the database and let you
use it as a table. Every time you access the view, the SQL
statement executes.
Materialized view - stores the results of the SQL in table
form in the database. SQL statement only executes once and
after that every time you run the query, the stored result
set is used. Pros include quick query results
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How would you copy the content of one repository to another repository?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How many number of sessions can one group in batches?
What is persistent lookup cache?
What are connected or unconnected transformations?
How to load a Dimension ? and how to load a fact table?
Performance tuning in UNIX for informatica mappings?
What does “tail –f” command do and what is its use as an Informatica admin.
what is $$$$?
What does refresh system mean, and what are its distinctive choice?
How do you migrate data from one environment to another?
When do you use sql override in a lookup transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to load data in informatica ?
