1)What are the database activities on data warehousing ?
2)Knowing all the things is good but As a dba what are all should be known to maintain data warehouse ?
Printable View
1)What are the database activities on data warehousing ?
2)Knowing all the things is good but As a dba what are all should be known to maintain data warehouse ?
This should cover it ...
http://otn.oracle.com/docs/products/...920/a96520.pdf
http://otn.oracle.com/docs/products/...920/a96521.pdf
http://otn.oracle.com/docs/products/...920/a96532.pdf
http://otn.oracle.com/docs/products/...920/a96533.pdf
http://otn.oracle.com/docs/products/...920/a96540.pdf
http://otn.oracle.com/docs/products/...920/a96612.pdf
Here's also an excellent article about data warehouse - https://www.cleveroad.com/blog/enter...data-warehouse
A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data. The data within a data warehouse is usually derived from a wide range of sources such as application log files and transaction applications.