Data Acquisition
Ashiya khan
Promote Dial | Digital Marketing Agency In Delhi (India) | Social Media Agency
In this stage, the data is acquired from the source data system like OLTP system and other external databases. It is the most time consuming and costly efforts in the data warehousing project, and is performed with software products known as ETL (Extract/Transform/Load) tools. The data acquisition is then an ongoing, scheduled process, which is executed to keep the warehouse relevant to a predetermined period in time. The ETL tool is used to extract data as per the warehouse subject from all data source, the data is cleaned, and is transformed as per the data warehouse structure for loading into the warehouse.
https://caindwarka.com