DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What are the database activities on data warehousing ?

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182
    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

  3. #3
    Join Date
    Nov 2020
    Posts
    1
    Here's also an excellent article about data warehouse - https://www.cleveroad.com/blog/enter...data-warehouse

  4. #4
    Join Date
    Feb 2021
    Posts
    1
    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.

  5. #5
    Join Date
    Oct 2023
    Posts
    1
    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
  •  


Click Here to Expand Forum to Full Width