Explain the difference between view and materialized view?
No Answer is Posted For this Question
Be the First to Post Answer
Give me a broad concept of what a data warehouse is, and what it might be used for?
What is the 4 + 1 view model as it relates to system modeling?
Can a dimension table contain numeric values?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what are the advantages and disadvantages of reporting directly against the database?
Is there any rownum object from which we can do this?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
5.Explain ODS ?
What are the differences between datamart vs. Reporting cube?
What is the difference between static cache and dynamic cache?
What is a data warehousing?
what is the difference between DSS and ODS ?