Abinitio Online Training
Chapter – 1 à Ab Initio Introduction

What is an ETL Tool?
Abinitio and its importance
Operating Systems & Hardware Platforms that it supports
Salient Features of Ab Initio
Products of Ab Initio Software Corporation

Ab Initio Co>Operating System ( Co>OP
Graphical Development Environment (GDE)
Ab Initio Enterprise Meta>Environment (EME)
Chapter-2 à Abinitio Architecture

What is the Anatomy of Running a Job?
What happens when we push the 'Run' Button?

Deployment Process
Host Process Creation
Agent Process Creation
Component Process Creation
Successful Component Termination
Agent Termination
Host Termination
Abnormal Component Termination
Chapter –3

How do we Connect from GDE to the Server

Host Profile File (.aih)
Connection, Co-Operating System, Shell & Host Directory
Abinitio Graph Development life cycle
How do we build a basic Ab Initio Graph? Using .dat(Data File) & .dml(Record Format File)

Chapter –4 à Dataset Components

Input File
Output File
Intermediate File
Lookup file
Editors in the GDE

Record Format Editor
Expression Editor
Transform Editor
Key Specifier Editor
Package Editor
Variables Editor
Sequence Specifier Editor
Transform Functions

Transform File(.xfr)
Functions, Variables, Statements & Rules
Chapter – 5 à Partition Components

Broadcast
Partition by Key
Partition by Expression
Partition by Percentage
Partition by Range
Partition by Round-Robin
Partition with Load Balancing
Chapter – 6 à De-partition Components

Concatenate
Gather
Interleave
Merge
Multifiles and Multidirectories

What is Parallelism – Types of parallelism

Component parallelism
Pipeline parallelism
Data parallelism
Repartitioning - When & Why

Chapter – 7 à Sort Components

Sort
Sort within Groups
Sample
Partition by Key & Sort
Phasing & Check Pointing

Reusability Features
Sub graphs
Chapter – 8 à Transform Components

Filter by Expression
Dedup Sorted
Reformat
Aggregate
Scan
Rollup
Join
Match Sorted
Normalize
Denormalize Sorted
Lookup Dataset's & DML Lookup Functions

Chapter – 9 à Database Components

Working with Database. Introduction Database Configuration File (.dbc)

Input Table
Output Table
Run SQL
Truncate Table
Update Table
Join with DB
Chapter – 10 à Miscellaneous Components

Redefine Format