Whatis the difference between View and Materialized View ?
Answer Posted / roshan
apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
What is informatica etl tool?
What is rank transformation?
What are batches?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is resilience time?
What is exclusive and normal mode for repository services?
What is meant by lookup transformation? Explain the types of lookup transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a dimensional model?
Explain the scenario which compels informatica server to reject files?
What are the designer tools for creating transformations?
Explain how many types of dimensions are available in informatica?
How to Create a folder using pmrep command?
can we override a native sql query within informatica? Where do we do it? How do we do it?