Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14447 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
Explain what transformation and how many are there in informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Design a mapping to load a target table with the following values from the above source?
Separate from an archive server and a powerhouse?
How to use procedural logic inside infromatica?
what is song in infrmatica...?
Explain what are the different types of transformation available in informatica.
What do you understand by term role-playing dimension?
How might one distinguish in the case of mapping is right or not without associating session?
How can we use mapping variables in informatica?
What is different between the data warehouse and data mart?
What is the maplet?
What does “tail –f” command do and what is its use as an Informatica admin.
How to generate sequence numbers using expression transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
