What is Data Acquisition Process?

The process of extracting the data from different source (operational databases) systems, integrating the data and transforming the data into a homogenous format and loading into the target warehouse database. Simple called as ETL (Extraction, Transformation and Loading). The Data Acquisition process designs are called in different manners by different ETL vendors.

            Informatica   —->  Mapping
            Data Stage   —->  Job
            Abinitio        —->  Graph