ab-initio-online-training

AB Initio Course Content

Overview:

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

Layouts

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