What is the difference between a table and the materialized
view?
Answer Posted / chandra
TABLE: A TABLE IS HAVING ALL THE COLUMS DATA
WHERE AS
MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is Cognos script editor?
How can we use batches?
What is aggregate cache in aggregator transformation?
Explain the tuning lookup transformation - informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the different types of olap? Give an example?
What is data transformation manager process?
What is meant by target load plan?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain the shared cache and re-cache?
How can you generate reports in informatica?
Implementation methodology
What is a sorter transformation?
To import the flat file definition into the designer where should the flat file be placed?