Ab Initio Course Training Chennai

Module 1

Introduction to Ab initio

Operating Systems

Hardware Platforms that it supports

Module 2

Products of Ab Initio Software Corporation

The Ab Initio Co-Operating System

Graphical Development Environment (GDE)

The Ab Initio Enterprise Meta Environment (EME)

Module 4

Salient Features of A Initio

Understanding the High Level Architecture of Ab Initio

What is the Anatomy of Running a Job?

What happens when we push the ‘Run’ Button?

Deployment Process

Module 5

Host Process Creation

Agent

Process Creation

Component Process Creation

Successful Component Termination

Agent Termination

Host Termination

Module 6

Abnormal Component Termination

How do we Connect from GDE to the Server

Host Profile File (.aih)-Connection, Co-Operating System, Shell & Host Directory

What is Graph Programming? What are the basic parts of an Ab Initio Graph?

Broad Classification of Components

Dataset Components-Program / Computing Components

Data Manipulation Language (DML)

Module 7

Record Formats-DML Expressions-Transform Functions-Key Specifiers

How do we build a basic Ab Initio Graph? Using dat(Data File) & dml(Record Format File) Dataset Components

Input File

Output File

Intermediate File

Lookup file

Editors in the GDE

Record Format Editor-Expression Editor

Transform Editor

Module 8

Key Specifier Editor

Package Editor

Variables Editor

Sequence Specifier Editor

Module 9

Transform Functions

Transform File(xfr)

Functions, Variables, Statements & Rules

Transform Components

Multistage and Advanced Components

Filter by Expression

Module 10

Dedup Sorted

Reformat

Aggregate

Scan

Rollup

Join

Match Sorted

Module 11

Normalize

Denormalize Sorted

Lookup Dataset’s & DML Lookup Functions Partition Components

Broadcast

Partition by Key

Partition by Expression

Partition by Percentage

Partition by Range

Partition by Round Robin

Partition with Load Balancing

Module 12

Multifiles and Multidirectories De-partition Components

Concatenate

Gather Interleave

Merge

What is Parallelism – Types

Component ||’sm

Pipeline ||’sm-Data ||’sm

Repartitioning – When & Why Layout Implications

Sort

Sort within Groups

Sample

Partition by Key

Sort

Check point Sorted

Working with Databases

Module 13

Introduction Database Configuration File (dbc)

Interactive Database Components (IDB)

Input Table

Output Table

Run SQL

Truncate Table

Update Table

Join with DB

Miscellaneous Components

Redefine Format

Gather Logs

Replicate

Run Program

Module 14

Thrash

Deprecated Components

Find Splitters

Compress Components

Compress Uncompress GZip Gunzip

File Transfer Protocol (FTP) Components

FTP From-FTP To

Testing and Validation of Ab Initio Graphs using Validate Components

Check Order

Compare Records

Validate Records

Generate Records

Generate Random Bytes

Compute Checksum

Compare Checksum

Module 15

Phasing & Checkpointing Reusability Features

Sub graphs Graph Parameters

The Ab Initio Enterprise Meta Environment(EME)

High level anatomy of the EME

Relation to sandbox environment

Checking in your sandbox

Module 16

Checking out a graph or a sandbox

Locking in order to change an object

Tagging

Common projects

Dependency and Impact analysis

Performance Tuning Ab Initio Graphs

What is Good Performance? Going Parallel Serial Inputs Phases Record Formats and Components Memory Usage Various Tips

Back