What is Data Acquisition

Data Acquisition means Extraction, Transformation & Loading.

Here we will extract data from different sources like COBOL, ERP, Operational etc and bring into our Staging Area. Staging Area is a temporary storage area. From Staging Area we will load data into DWH or DM’s.

§  Data acquisition process is defined with Data extraction, Data transformation and Data loading.

                                I.Data Extraction:

                                             It is a process of reading the data from different sources like Operational sources, EPR systems, COBOL files, Flat files etc.

                              II.Data Transformation:

                                             It is a process of transforming data from one format to required business format. In Data transformation we are having 4 types.

                                                      i.Data Merging: It is a process of integrating the data from similar sources with the         

                                                                                 similar structure and data type.

                                                       ii.Data Cleansing: It is a process of identifying and changing the inconsistencies and

                                                                                     in accuracies.

                                                      iii.Data Scrubbing: It is a process of deriving new definitions from existing source

                                                                                     definitions.

                                                     iv. Data Aggregation: It is a process of where multiple detail values are summarized  

                                                                                      into a single summary values typically numeric like Sum,

                                                                                     Average, Min, Max etc