Extract, Transform, Load ETL

1
Extract, Transform, Load (ETL)

Extract, Transform, and Load (ETL) is a process
in data warehousing that involves extracting data
from outside sources, transforming it to fit
business needs (which can include quality
levels), and ultimately loading it into the end
target, i.e. the data warehouse.
2
What Does Ab Initio Mean?

• Ab Initio is a Latin phrase that means
• Of, relating to, or occurring at the beginning
  first

3
About Ab Initio
Ab Initio is a general purpose data processing
platform for enterprise class, mission critical
applications such as data warehousing,
clickstream processing, data movement, data
transformation and analytics. Supports
integration of arbitrary data sources and
programs, and provides complete metadata
management across the enterprise.
4
Ab Initio base software consists
of three main pieces

• Ab Initio CogtOperating System and core
  components
• Graphical Development environment(GDE)
• Enterprise Metadata Environment(EME)

5
Ab Initio Overview
User
CogtOperating system
GDE
EME
User
User
6
What is Graph Programming?
Boxes for processing and Data Transforms Arrows
for Data Flows between Processes Cylinders for
serial I/O files
Divided cylinders for parallel I/O files Grid
boxes for database tables
7
Sample Graph Simple Sort Graph
8
Example of a Rollup Graph
Expanded View
Global View
9
Example Of Data Partitioning Graph
Expanded View
Global View
10

• THANK YOU