Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56444 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / surajit n bhowmick
A View is just a stored query and has no physical role.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache.
A materialized view has a physical table associated with
it, it does not have to resolve the query each time it is
queried. Depending on how large the result and how complex
the query, a materialized view should perform better.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
What is a router transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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?
How do you load alternate records into different tables through mapping flow?
Can we change Dynamic to Static or Persistent cache? If so what happens?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How does the aggregator transformation handle null values?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is an expression transformation in informatica?
What is native users?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
