Duration:

Online  Fee: 

Classroom Fee: 

Introduction to Abinitio – Operating Systems & Hardware Platforms that it supports

 Products of Abinitio Software Corporation

  • The Abinitio Co-Operating System
  • Graphical Development Environment (GDE)
  • The Abinitio Enterprise Meta>Environment (EME)

Salient Features of Abinitio

 Understanding the High Level Architecture of Abinitio

Understanding the High Level Architecture of Abinitio

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 Abinitio Graph?

 

Data Manipulation Language (DML)

  • Record Formats
  • DML Expressions
  • Transform Functions
  • Key Specifies

How do we build a basic Abinitio Graph?

 

What is Parallelism – Types

  • Component Parallelism
  • Pipeline Parallelism
  • Data Parallelism

Sandbox – Types

 

  • Private Sandbox
  • Public Sandbox

Editors in the GDE

 

  • Record Format Editor
  • Expression Editor
  • Transform Editor
  • Key Specifier Editor
  • Package Editor
  • Variables Editor
  • Sequence Specifier Editor

Dataset Components

 

  • Input File
  • Output File
  • Intermediate File
  • Lookup File
  • Lookup Template
  • Block-Compressed Lookup Template

Transform Components – Multistage and Advanced Components

 

  • Aggregate
  • Dedup Sorted
  • Denormalize Sorted
  • Filter By Expression
  • Join
  • Multi Reformat
  • Normalize
  • Update Table
  • Join With DB

Sort Components

 

  • Sort
  • Sort Within Groups
  • Sample
  • Partition by Key and Sort
  • Check Pointed Sort

Validate Components

 

  • Check Order
  • Compare Records
  • Create Data
  • Generate Recorders
  • Validate Records

Working with Database’s. Introduction Database Configuration File (.dbc)

 

Lookup Functions

  • Lookup Local
  • Lookup Count
  • Lookup First
  • Lookup Last
  • Lookup Next

Strings

 

  • String_char
  • String_concat
  • String_filter
  • String_filter_out
  • String_length
  • String_irepad
  • String_rindex
  • String_substring
  • String_upcase
  • String_split
  • String_lenght
  • Os

Using .dat (Data File) & .dml(Record Format File)

 

  • Reformat
  • Rollup
  • Scan
  • Scan with Rollup

Partition Components

 

  • Broadcast
  • Partition by Key
  • Partition by Expression
  • Partition by Percentage
  • Partition by Range
  • Partition by Round-Robin

De-Partition Components

 

  • Concatinate
  • Gather
  • Interleave
  • Merge

Miscellanious Components

 

  • Redefine Formate
  • Gather Logs
  • Replicate
  • Run Program
  • Trash

Compress Components

 

  • Compress
  • Uncompress
  • Deflate
  • Inflate

Interactive Database Components

 

  • Input Table
  • Output Table
  • Run SQL
  • Run Program
  • Trash

Multifiles and Multidirectories(MFS)

 

Phasing & Checkpointing

Reusability Features

  • Sub Graphs
  • Graph Parameters
  • Psets

The Abinitio Enterprise Meta Environment (EME)

 

  • High Level Anotomy Of the EMI
  • Relation to Sandbox Environment
  • Checking in You Sanbox
  • Checking out a graph or a sandbox
  • Looking in order to change an objext
  • Tagging
  • Common Projects
  • Depandancy and Impact Analysis

Performance Tuning

Implementation of SCD’s(Slowly Changing Dimensions)

 

  • SCD-Type1
  • SCD-Type2
  • SCD-Type3

Advance Features

 

  • PDL (Parameter Definition language)
  • Meta Programming
  • Debugging Techniques
  • Plan It
  • Real Time Scenario