Home - IT Training - Our Programs - Abinitio Corporate Training

Ab Initio - An introduction
In this course participant’s work through a number of instructor led hands-on exercises. Participants also complete a set of integration exercises in which business oriented world problems are answered by building Ab Initio graphs.

After working with Ab Initio in a development environment, users may wish to get more in depth training in several areas. This course is designed to deliver instructions in a variety of advanced topics too. We can work with you to tailor this course to meet your needs.

Course Content:

Module I: Introduction to Ab Initio. Operating Systems & Hardware Platforms that it supports

Module II: Products of Ab Initio Software Corporation

• The Ab Initio Co-Operating System
• Graphical Development Environment (GDE)
• The Ab Initio Enterprise Meta-Environment (EME)

Module III: Salient Features of Ab Initio

Module IV: 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
• Host Process Creation
• Agent Process Creation
• Component Process Creation
• Successful Component Termination
• Agent Termination
• Host Termination
• Abnormal Component Termination

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

• 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)

• 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
• Key Specifier Editor
• Package Editor
• Variables Editor
• Sequence Specifier Editor

Transform Functions

• Transform File(.xfr)
• Functions, Variables, Statements & Rules

Transform Components - Multistage and Advanced Components

• Filter by Expression
• Dedup Sorted
• Reformat
• Aggregate
• Scan
• Rollup
• Join
• Match Sorted
• 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

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 Database’s. 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
• 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

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
• 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

Duration:

• 36-38 Hours. 3 days per week. 6-7 hours per day.

Contact us
For more information about this course write to queries@teknowledge.in or walk into our IT Training centers located in Bangalore.