Ab Initio

What you will learn

Ab Initio Server Hardware

Ab Initio Installation

Ab Initio Data Profiles

Ab Initio File Systems and Heterogeneous Database Systems

Ab Initio Data Integration Design Specifications

Ab Initio Application Graphs

Ab Initio Application Test Plan

Ab Initio Graph Development Standards Checklist

Ab Initio Lifecycle Migration

Ab Initio Application Operations

Who Should Attend

Developers with any RDBMS Applications

Module I: Introduction to Ab Initio

Salient Features of Ab Initio

Module II: AbInitio Architecture

The Ab Initio Co-Operating System

Graphical Development Environment (GDE)

Intro to The Ab Initio Enterprise Meta-Environment (EME)

Module III: Sandbox and Parameter details

What is sandbox and its usage

Public and private parameters

Module IV: Graph Programming

What is graph programming and basic parts of AbInitio graph building

What is the Anatomy of Running a Job

How do we Connect from GDE to the Server (Run ? Settings)

Broad classification of components

Editors in the GDE

XFR and its usage

Module V: Data Manipulation Language Overview (DML)

Record Formats

DML Expressions

Transform Functions

Key Specifiers

Module VI: Components · Dataset Components

Input File

Output File

Intermediate File

Lookup file

Transform Components

Filter by Expression

Dedup Sorted

Reformat

Aggregate

Scan

Rollup

Join

Match Sorted

Partition Components

Broadcast

Partition by Key

Partition by Expression

Partition by Percentage

Partition by Range

Partition by Round-Robin

Partition with Load Balancing

De-partition Components

Concatenate

Gather

Interleave

Merge

Database Components

Input Table

Output Table

Run SQL

Truncate Table

Update Table

Join with DB

Sort Components

Sort

Sort Within Groups

Miscellaneous Components

Redefine Format

Gather Logs

Replicate

Run Program

Trash

Module VII: Parallelism

Component Parallelism

Pipeline Parallelism

Data Parallelism

Multifile

Module VIII: AbInitio functions

AbInitio in-build functions

Lookup fuctions

Module IX: AbInitio Best Practices and Performance Tuning

Phasing and Checkpoints

Sub-graphs

Serial Input Vs Multifile

Fan-In and Fan-Out