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 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

✔ 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)

✔ 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
✔ Sort within groups
✔ Partition by key and sort

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

✔ 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

✔ Multi files
✔ Layout
✔ Parallelism Techniques

✔ Pipeline Parallelism
✔ Component Parallelism
✔ Data Parallelism

✔ Phases and checkpoints
✔ Rollback Recovery mechanism

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

✔ 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

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

✔ Gather
✔ Interleave
✔ Merge
✔ Concatenate

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

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

✔ Replicate
✔ Gather logs
✔ Redefine format
✔ Run program

✔ Air commands
✔ Tagging commands

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

✔ 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

“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.

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

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

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.

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


Excellent institute for Online WebMethods Course and I recommend VISWA Technologies thank you For arranging such a great faculty
Today is the last class for online RPA course i am thankful to Chaitanya sir for such a great training and I thank to admin team
Bodicherla Jagadeeswar
Bodicherla Jagadeeswar
Recently completed online Microsoft Intune training course By "Rajendra Prasad" and I recommend VISWA Online Trainings for this course and also thank you admin team
Penchalakumar Ganji
Penchalakumar Ganji
Best institute for Linux, AWS online course by Musab sir. I thank Chaitanya sir for arranging our classes
Konduru Akhil
Konduru Akhil
Hi, Overall training classes are very good.All the instructions are kind and patient.I look forward to take more classes from Viswa online trainings.
Eswar Tech
Eswar Tech
I enroll for aws solution architecture course. It was great learning with viswa technologies. Thanks team.
Manikanta Goud
Manikanta Goud
I am really satisfied. Best training institute. Thanks Chaitu
S Rambabu 6228
S Rambabu 6228
Best online training institute. I have more experience with java srinath trainer.
gaddam Manojkumar
gaddam Manojkumar
They have a professional approach by their trainer and support team. Personally, I liked the instructor's way of teaching and also helping us if we have any doubts after the class.
Ramesh Metta
Ramesh Metta
They have teachers with strong expertise. The AWS course i have taken was good and had full support from team.

Quick Links