Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56463 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / senthil
hi,
we already know basic restrictions of view and materialized
view,
view is a logical or virtual table it doesn't have data on
its own, but materialized view has a physical structure it
stores data in local machine or on its own.materialized view
can be refreshed automatically or manually. but in view, if
any changes happened in the base tables, we want to reflect
the same in the view means view has to issue the select
statement again to the database
| Is This Answer Correct ? | 71 Yes | 6 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
What are the different clients of powercenter?
What is joiner change?
What is a stored procedure transformation?
What is the function of union transformation?
tell me 5 session failure in real time how can you solve that in your project?
Why sorter is an active transformation?
Enlist the differences between database and data warehouse.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
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.
What is rank transformation?
How do you update the records with or without using update strategy?
update strategy transformation in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
How can we use mapping variables in informatica? Where do we use them?
