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.
Database activities in data warehousing primarily involve data extraction, transformation, and loading (ETL) processes, data storage, data retrieval, and data analysis. ETL operations are essential for moving data from source systems to the data warehouse, while storage and retrieval support efficient data management and access. Data analysis includes querying, reporting, and data mining to derive valuable insights.
As a database administrator (DBA) responsible for maintaining a data warehouse, one should have expertise in ETL tools, data modeling, SQL, performance optimization, and security measures. xx