What is the difference between view and materialised view?
- 6 Answers
- 12476 Views
- I also Faced
- E-Mail Answers
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
How many numbers of sessions can one group in batches?
what is Active lock explain
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How do we call shell scripts from informatica?
lookup transformation with screenshots
What is rank transform?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How we can create indexes after completing the load process?
How do you load unique records into one target table and duplicate records into a different target table?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain what is informatica metadata and where is it stored?
what is song in infrmatica...?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain the shared cache and re-cache?
