What is the difference between view and materialised view?
Answer Posted / sarvesh
VIEW IS THE VIRTTUAL TABLE,AND WE CANOT REFRESH THE
DATA ,BUT IN MATERIALISED VIEW WE CAN REFRESH THE DATA
FREQUNENTLY,AND BY USING M.VIEW THE PERFORMANCE WILL BE
INCREASED.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
How might you approve all mappings in the archive all the while?
Mention few power centre client applications with their basic purpose?
Describe an informatica powercenter?
What is lookup transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the different versions of informatica?
What are some examples of informatica etl programs?
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?
What is confirmed fact in dataware housing?
What is Index Caches size?
How many input parameters can exist in an unconnected lookup?
What is meant by target load plan?
What is the meaning of decode in informatica?