Demo Video

watch Ab Initio Demo Video

About Trainer

  • Trainer Information
  • Trainer Name : Kumar
  • Training Version : 2.10 Only Available version for Abinitio
  • Work Experience : Around 6yrs
  • Online Training Exp : 2Yrs
  • Classroom Training Exp : 2Yrs
  • Batches Trained : Around 35 batches
  • Students Trained : 150 students
  • Training services (Mark YES or NO)
  • Course Duration : 30-35days
  • Version : 2.10
  • Project Support : Yes
  • Installation Guidance : Yes
  • FAQ’s : Yes
  • Interview Questions : Yes
  • Resume Preparation : Yes
  • Course Material : Yes
  • Additional Information : Yes

Course Outlines

Ab Initio Course Curriculum

Click Here for a Complete Course Contents
Data warehousing Concepts
Introduction to Ab Initio.
Operating Systems & Hardware Platforms that it supports
Products of Ab Initio Software Corporation

  • The Ab Initio Co>Operating System
  • Graphical Development Environment (GDE)
  • The Ab Initio Enterprise Meta>Environment (EME)
Salient Features of Ab Initio 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?
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)
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
  • DEDUP SORTED
  • FILTER BY EXPRESSION
  • JOIN
  • MULTI REFORMAT
  • NORMALIZE
  • 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
  • CONCATENATE
  • GATHER
  • INTERLEAVE
  • MERGE
Miscellaneous Components
  • REDEFINE FORMAT
  • GATHER LOGS
  • REPLICATE
  • RUN PROGRAM
  • TRASH
Compress Components
  • COMPRESS
  • UNCOMPRESS
  • DEFLATE
  • INFLATE
Interactive Database Components (IDB)
  • INPUT TABLE
  • OUTPUT TABLE
  • RUN SQL
  • UPDATE TABLE
  • JOIN WITH DB
Sort Components
  • SORT
  • SORT WITHIN GROUPS
  • SAMPLE
  • PARTITION BY KEY AND SORT
Validate Components
  • CHECK ORDER
  • COMPARE RECORDS
  • CREATE DATA
  • GENERATE RECORDS
  • VALIDATE RECORDS
Working with Database’s. Introduction Database Configuration File (.dbc)Lookup Functions
  • Lookup Local
  • Lookup Count
  • Lookup First
  • Lookup Last
  • Lookup Next
String Functions
  • String_char
  • String_concat
  • String_filter
  • String_filter_out
  • String_length
  • String_lrepad
  • String_rindex
  • String_substring
  • String_upcase
  • String_split
  • String_length
Multifiles and Multidirectories(MFS) Phasing & Check pointing Re-usability 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
Implementation of SCD’s(Slowly Changing Dimensions)
  • SCD-Type1
  • SCD-Type2
  • SCD-Type3
Advanced Features
  • Debugging Techniques
  • Plan.It
  • Performance Tuning
  • PSETS

Resources

Ab Initio Job Trends

Ab Initio USA Job Trends
Ab Initio India Job Trends