Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14653 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepika
a view is like window through which we can acess the data.
it doesnot store the data,where as materialized view can
contain data also.this can be used for pre computed complex
calulations.
materialized views are called snapshots before oracle 9i
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is Cognos script editor?
What is the sequence generator transformation in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Define mapping and session?
What is target designer and target load order?
What are the limitations of joiner transformation?
What is data transformation manager process?
What is a surrogate key?
What is the procedure for creating independent data marts from informatica 7.1?
What is the command used to run a batch?
Briefly define reusable transformation?
What is joiner transformation in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
