Page 82 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

Transform Notes

The transformation stage applies a series of rules or functions to the extracted data to derive the
data for loading into the end target. Some data sources will require very little or even no
manipulation of data.

Load

The loading phase loads the data into the end target, usually the Data Warehouse (DW). Some of
the data warehouses may overwrite existing information frequently; updating data is done on
a daily, weekly, or monthly basis.

5.7 Meaning and Tools of Extraction

Data extraction is the act or process of retrieving data from data sources for further data processing.
Usually, the term data extraction is applied when data is first imported into a computer from
primary sources like measuring or recording devices.

5.7.1 Tools

A good ETL tool must be able to communicate with different relational databases and read the
various file formats used throughout an organization. Many ETL vendors now have data profiling,
data quality, and metadata capabilities. A common use case for ETL tools include converting
CSV files to formats readable by relational databases.
Popular ETL Tools are:
IBM WebSphere Information Integration

Ab Initio
Informatica
Talend
Figure 5.6 depicts an ETL Tools Comparison chart.

Figure 5.6 ETL Tools Comparison

Source: https://sheet.zoho.com/publicgraphs/983047000000039763.png

LOVELY PROFESSIONAL UNIVERSITY 77