Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14203 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 ways are there to create ports?
What is the command used to run a batch?
What are the different transaction levels available in transaction control transformation?
How to generate sequence numbers without using the sequence generator transformation?
What is mapping debugger?
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
lookup transformation with screenshots
What is complex mapping?
What is the session task and command task?
What is lookup change?
What will be the approach?
Define the various join types of joiner transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is status code in informatica?
What are the performance considerations when working with aggregator transformation?
