Learn Informatica powercenter (ETL) with Free Lessons & Tips

Data 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.