|
-
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 ?
J Gangadhar
-
-
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
Last edited by Steve R Jones; 12-12-2023 at 04:31 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote