IT Training Courses
IT Training Courses

Do you need IT and Project Management Training ?

COMNet Group can help with your IT Training Needs!  Please call our support numbers now:


North Carolina: 

Charlotte Area: (704) 323-7762

RTP Area: (919) 827-4364


South Carolina: 

Rock Hill : (803) 403-1970



Chicagoland Area: (847) 458-8281


or send us an email at




Schaumburg/Hoffman Estates Area:

COMNet Group Inc.

2815 Forbs Avenue, Suite 107

Hoffman Estates, IL 60192



Gurnee/Waukegan/Grayslake/Lake Forest Area:

COMNet Group Inc.

100 Saunders Road, Suite 150

Lake Forest, IL 60045


Naperville/ Oakbrook Area:

COMNet Group Inc.

4320 Winfield Road, Suite 200

Warrenville, IL 60555





University Executive Park Area


COMNet Group Inc.

301 McCullough Drive, Suite 400

Charlotte, NC 28262

Phone: (704) 323-7762



Cary/Raleigh Area - Weston Parkway


COMNet Group Inc.

5000 Centregreen Way, Suite 500

Cary, NC 27513

Phone: (919) 827-4364





Rock Hill:

COMNet Group Inc.

331 East Main Street, Suite 200

Rock Hill, SC 29730

Phone: (803) 403-1970





Santa Clara / Silicon Valley:

COMNet Group Inc.

5201 Great America Pkwy, Suite 320
Santa Clara, CA 95054

Phone: (408) 916-4937


ETL Development (Ab Initio)

The Ab Initio software is a Business Intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, Enterprise Meta>Environment, Data Profiler and Conduct. It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis.

Who Should Attend
The primary audiences for this course are: ETL Admins, ETL and BI Developers




  • Ab Initio Architecture
  1. Ab Initio Product Architecture
  2. Client server Communication
  3. Ab Initio - Process Flow
  4. Co>operating System
  5. Graphical Development Environment
  • Overview of Graph

a.   The Graph Model

b.   Parts of Typical Graph

c.   Layout and Phase of Graph

d.   Anatomy of a running job

  • Ab Initio Functions
  1. Data Manipulation Language
  2. Built-in Functions
  3. Lookup File
  4. Transform Functions
  • Basic Components
  1. Reformat
  2. Filter by Expression
  3. Redefine Format
  4. Replicate
  5. Aggregate
  6. Sort
  7. Join
  8. Dedup sorted
  • Partitioning and De-partitioning Components
  1. Multi-files
  2. Parallelism Concepts
  • Component Parallelism
  • Pipeline Parallelism
  • Data Parallelism
  1. Partitioning Components
  • Broadcast
  • Partition by Key
  • Partition by Expression
  • Partition by Round-Robin
  • Partition by Range
  • Partition by Percentage
  • Partition by Load Balance
  • De-partitioning Components
    • Gather
    • Concatenate
    • Interleave
    • Merge
    • AI Graph Environment

a)     Environment Set up

b)     Sandbox & graph parameters

c)      Private and Public Sandbox

d)     Parameters sourcing technique

  • DB components & connectivity

a)     Input Table

b)     Output Table

c)      Update Table

d)     Truncate Table

e)     Run SQL

f)       DBC File

  • Advance components

a)     Normalize

b)     De-normalize Sorted

c)      Meta Pivot

d)     Multi Reformat

e)     Inflate

f)       Deflate

g)     Assign Keys

h)     Scan

i)       Sort within Group

j)       Match Sorted

k)     Rollup

l)       Conditional Components

m)   Vectors

n)     Custom Layouts

  • Control Statements (if, for, while, etc.)
  • Performance Tuning Tips
  • EME basics

a)     Check-in

b)     Check-out

c)      Tagging

  • MFS

a)     MFS Commands

  • Debugging


  • EME Administration

a)     Features of EME

b)     Sandbox and projects

c)      Checking out graphs, files and projects

d)     Checking in projects, sandboxes, graphs and files

e)     Dependency analysis

f)       Using web to access EME datastore

g)     Reports, Versioning and Tagging

h)     Air commands



Course Number:


Print Print | Sitemap
© COMNet GROUP INC. 2020 All Rights Reserved.