0Data Acquisition:
GUI based ETL
ETL applications can be designed with a simple graphical user interfacing point and click techniques
Ex: Informatica, Datastage, Abintio
ODI(Oracle Data Integrator) – It is previously known as Oracle Warehouse Builder(OWB).
Data Extraction E
It’s a process of reading the data from various source systems.
The following are the various types of sources
Relational sources:
a.Oracle b. SQL server c. DB2 d. Informics
ERP Sources:
SAP, Peoplesoft, J.D.Ewards, Oracle Apps
Legacy Sources:
Mainframes , Cobol files
File Sources:
Flatfiles,XML files, CSV files
Data Transformation T
It’s a process of converting the data and cleansing the data into the required business format
A Staging Area is a temporary memory of buffer where the data transformation activities take place.
The following are the various data transformation activities take place in the staging.
- Data Merging
- Data Cleansing
- Data Scrubbing
- Data Aggregation
- Data Loading L
Data Loading:
It’s a method of inserting the data into a target system
There are two types of data loads.
1.Initial Load (or) Full Load
Its a process of inserting all the required data into an empty target table.
2. Incremental Load (or) Delta Load
Its a process of inserting only new records after initial load.
