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