Crescent Help Desk

Google Plusface booktin
AB Initio Course Content


Ab Initio is works with the client-server model. It is a fourth generation data analysis, data manipulation, batch processing graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data.

Training Objectives of AB Initio:

AB Initio software was designed to support a complete range of business applications, from simple to the most complex. The client is called "Graphical Development Environment" (you can call it GDE).It resides in user desktop. The server or back end process is called Co-Operating System". The Co-Operating System can reside in a mainframe or UNIX remote machine.

Target Students and Prerequisites

Students must have knowledge on SQL and PL/SQL and Basic Knowledge on UNIX Shell Scripting.

Abinitio Course Contents
Introduction to Abinitio
Abinitio Architecture
Graph Programming
Introduction to .dat and .dml files
Partition Components
  • Braod Cast
  • Partition by Expression
  • partition by range
  • partition by community
  • partition by percentage
  • partition by Round Robin
Departition Components
  • • Concatenate
  • • Gather
  • • Interleave
  • • Merge
Multifile System(MFS)
Types of parallelism

Sort Components
  • Sort
  • Sort with in groups
  • Sample
  • Partition by key and sort
Transform Components>
  • Filter by expression
  • Aggregate
  • Scan
  • Rollup
  • Denormalize Sorted
  • Normalize
  • Reformat
  • Match sorted
  • Dedup sorted
Working with Databases
Database components
  • Run SQL
  • Input Table
  • Output Table
  • Truncate Table
  • Update table
Phase and check Points
Miscellaneous component
  • Gather logs
  • Run program
  • Redefine format
  • Trash
  • Replicate
Dataset Components
  • Input File
  • Output File
  • Lookup File
  • Intermediate File
FTP Components
  • FTP From
  • FTP To
Compress Components
  • Compress
  • Uncompress
  • Gzip
  • Gunzip
Validate Component
  • Check Order
  • Generate Records
  • Generate Random bytes
  • Compare Records
  • Compute Check Sum
  • Compare Check Sum
Translate components
  • Record XML
  • Write XML
Project and Sandbox
Performance Tuning