Ab Initio Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9

Learners : 1080

Duration :  30 Days

About Course

Ab Initio means “starts from the beginning”. Ab-Initio program works with the client-server model. The client is referred to as a “Graphical development environment” (GDE). The server is called Co-Operating System”. The Co-working system can dwell on a mainframe or UNIX machine. The Ab-Initio code is referred to as graph, which has received .mp extension. The graph from GDE is required to be deployed in corresponding. Ksh version. In a Co-operating approach the corresponding. Enroll now and get certified in it.

Ab Initio Training Course Syllabus

Unix Basics:

✔ Unix Architecture
✔ Unix basic commands

✔ ls, cp, mv, rm, mkdir, rmdir, cat, find, sed, awk, grep, egrep, ps, top, head, tail, gzip, gunzip, chmod, vi editor commands, more, nohup

Datawarehousing Basics:

✔ Overview of Datawarehousing
✔ Difference between OLTP & OLAP
✔ Dimension table
✔ Fact table
✔ Star schemas
✔ Snowflake schemas
✔ Datamart
✔ Galaxy Schemas
✔ Confirmed dimension tables
✔ Degenerate dimension tables
✔ Junk dimension tables
✔ Factless fact tables
✔ Slowly changing dimensions (SCD)

Ab Initio Basics:

✔ Overview of AbInitio features
✔ Ab Initio Architecture
✔ Anatomy of a Job execution
✔ GDE overview
✔ GDE to Host profile creation
✔ About Datasets, Tables
✔ Building and execution of the graph

Sort Components:

✔ Sort
✔ Sort within groups
✔ Partition by key and sort

Transform Components:

✔ Reformat
✔ Join
✔ Rollup
✔ Scan
✔ Normalize
✔ Fuse
✔ Scan with Rollup
✔ Dedup Sorted
✔ Filter by Expression
✔ Multi Reformat

Basic concepts – Primary:

✔ Project structure
✔ Sandbox structure
✔ Sandbox parameters
✔ Data directories creation
✔ Abinitiorc file
✔ Sandbox setup
✔ Private projects
✔ Public projects
✔ Difference between Private and public projects
✔ Check-in through GDE
✔ Check-out through GDE
✔ Check-in through command level
✔ Check-out through command level

Basic concepts – Secondary:

✔ Multi files
✔ Layout
✔ Parallelism Techniques

✔ Pipeline Parallelism
✔ Component Parallelism
✔ Data Parallelism

✔ Phases and checkpoints
✔ Rollback Recovery mechanism

Dataset Components:

✔ Input file
✔ Output file
✔ Intermediate file
✔ Read excel
✔ Write excel
✔ Lookup Template

Database Components:

✔ Input Table
✔ Output Table
✔ Update Table
✔ Run SQL
✔ Truncate table
✔ Join with DB
✔ Call stored procedure


✔ Overview of Lookups
✔ Static Lookups
✔ Dynamic lookups
✔ lookup() function
✔ lookup_local() function
✔ lookup_count() function
✔ lookup_next() function
✔ lookup_add() function

Partitioning Components:

✔ Partition by key
✔ Partition by Round Robin
✔ Partition by expression
✔ Partition by percentages
✔ Partition with load balance
✔ Broadcast

Departitioning Components:

✔ Gather
✔ Interleave
✔ Merge
✔ Concatenate

Partitioning Scenarios

Compress & FTP Components:

✔ Compress
✔ Decompress
✔ Deflate
✔ Inflate
✔ ftp from
✔ ftp to

Validate Components:

✔ Validate
✔ Check order
✔ Generate records
✔ Create data
✔ Compute checksum
✔ Compare checksum
✔ Compare records


Miscellaneous components:

✔ Replicate
✔ Gather logs
✔ Redefine format
✔ Run program


✔ Air commands
✔ Tagging commands


✔ SCD type-1 implementation
✔ SCD type-2 implementation

AbInitio Advanced Topics:

✔ User-defined sandbox level parameters
✔ Parameters Introduction and interpretation
✔ Graph level parameters
✔ Generic graphs
✔ Psets
✔ Plans
✔ Conditional Components
✔ Optimization Techniques
✔ Metaprogramming
✔ Debugging Techniques
✔ End to End SDLC flow
✔ DBC file creation and generalizing to various environments

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Ab Initio Training - Upcoming Batches

7th NOV 2022



Coming Soon



5th NOV 2022



Coming Soon



Don't find suitable time ?


Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Ab Initio Training FAQ'S

Mention what is Abinitio?

“Abinitio” is a latin word meaning “from the beginning.” Abinitio is a tool used to extract, transform and load data. It is also used for data analysis, data manipulation, batch processing, and graphical user interface based parallel processing.

Explain what is the architecture of Abinitio?

Architecture of Abinitio includes

  • GDE (Graphical Development Environment)
  • Co-operating System
    Enterprise meta-environment (EME)
  • Conduct-IT

Get ahead in your career by learning Ab Intio through VISWA Online Trainings

Mention what is the role of Co-operating system in Abinitio?

The Abinitio cooperating system provide features like

  • Manage and run Abinitio graph and control the ETL processes
  • Provide Ab initio extensions to the operating system
  • ETL processes monitoring and debugging
  • Meta-data management and interaction with the EME

Explain what does dependency analysis mean in Abinitio?

In Ab initio, dependency analysis is a process through which the EME examines a project entirely and traces how data is transferred and transformed- from component to component, field-by-field, within and between graphs.

Mention how can you connect EME to Abinitio Server?

To connect with Ab initio Server, there are several ways like

  • Login to EME web interface- http://serverhost:[serverport]/abinitio
  • Through GDE, you can connect to EME data-store
  • Through air-command


vishal meda
vishal meda
They give trainings properly and trainers are well versed with them where i recommend to all viswa trainings are good!!
Ntr fan
Ntr fan
I just finished sap bods training in Hyderabad. Excellent course and curriculum 100% doubt clarification sessions. Thanks Chaitanya
Shiva Krishna
Shiva Krishna
I recently completed informatica online training with Chaitanya. Course was built by excellent trainer. And process of learning was streamlined. Thanks
Mohammad ali syed
Mohammad ali syed
It was great and smooth understandable training. You can learn lots.
Govinda Bhatia
Govinda Bhatia
Not recommended as there will be no server access working to do practical after training. Also there will be no fix for the same. So it's wastage of money. If server access not at all working then no meaning to provide server access. Also it not working for single day properly. Need to followup daily but in response you told will fix that sir at home once he will back will fix. After he came back again it's not working and not able to fix for single day also Every time new excuse it's wastage of money.
M Leela mohan
M Leela mohan
I took SQL Server and MSBI Online training with Murali Krishna. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with VISWA Online Trainings.
Attended live Virtual training for IoT Trainer was very good. He had excellent knowledge of IoT and was very good at explaining concepts in detail.…
Lakshmi Lakshmi
Lakshmi Lakshmi
Best sap commerce cloud and Spartacus training institute in india. He provides a great mix of listening, speaking, and practical learning activities and a very safe, supportive learning environment. He maintains a friendly relationship with the students during class. He not only teaches but also monitors our practice status on daily basis.
Ch Chandranath
Ch Chandranath
I have undergone Oracle Tuning training. I can proudly say that this is one of the best training institutes available in the market. The way Mr. Kumar teaches the concepts and makes them understandable is very commendable and unique. Even a novice can clearly understand the concepts clearly after attending his classes.

Quick Links