1000+ Unique Technologies Projects Delivered | 500+ Corporate Customers Worldwide | 50000+ Professionals Trained on 40+ Domains in Over 30 Countries | Just Launched B2I Offerings | Live, Instructor-led.

Ab Initio

This web-based training course on Ab Initio functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

The Ab initio software suit contains a number of data analysis, batch processing and data manipulation tools and is entirely graphical user interface which allows parallel processing. It is commonly used to extract, transform and load data into the system framework while processing and implementing real time data. With a two tier architecture, the graphical development environment of Ab initio coupled with the co-operating system creates a client-server architecture. The Ab Initio system comprises of a number products such as GDE, Co>operating system, Enterprise Meta, the component library, quality environment and more. With Ab Initio, users gain the advantage of a user friendly homogeneous and heterogeneous platform which allows the processing of parallel data streams.


Reviews , Learners(390)



Course Details

This Ab Initio consultative learning solution provides high level of both applicative and theoretical knowledge in one and all products and tools of the Ab Initio software suit. The learning solution is structured specifically for enterprises and organizations willing to endorse the software tool for growth in terms of data manipulation and processing. The learning solution provides the option to be customized and modified as per the requirements of the clients so that the end requirements and goals of the client are met.


Introduction to Ab Initio

  • Why it is a market leader in ETl
  • Key features in Ab initio
  • Where it is being used and how helps complex business

Understanding the High Level Architecture of Ab Initio

  • Deployment Process
  • Master Process Creation
  • Agent Process Creation
  • Component Process
  • Component Termination
  • Agent Termination
  • Host Termination

Data Manipulation Language (DML)

  • Record Formats
  • DML Expressions
  • Transform Functions
  • Input File
  • Output File
  • Intermediate File
  • Lookup file
  • Transform File(.xfr)
  • Functions, Variables, Statements & Rules

Transform Components

  • Filter by Expression
  • Dedup Sorted
  • Reformat
  • Aggregate
  • Scan
  • Rollup
  • Join
  • Match Sorted
  • Normalize
  • Denormalize Sorted

Working with Database

  • Input Table
  • Output Table
  • Run SQL
  • Truncate Table
  • Update Table
  • Join with DB

Various Miscellaneous Components

  • Redefine Format
  • Gather Logs
  • Replicate
  • Run Program
  • Thrash

How to Validate Components

  • Check Order
  • Compare Records
  • Validate Records
  • Generate Records
  • Generate Random Bytes
  • Compute Checksum
  • Compare Checksum

The Ab Initio Enterprise Meta> Environment(EME)

  • High level anatomy of the EME
  • Connection to the sandbox environment
  • How to check your sandbox
  • Checking out a graph or a sandbox
  • Locking in order to change an object
  • Tagging methods
  • Implementing Common projects
  • Phasing and check pointing
  • Working with Real time scenarios

Our Clients

B2B Technical Trainings Projects Delivered


Read More