IT Training Courses
IT Training Courses

Do you need IT and Project Management Training ?

COMNet Group can help!  Please call our support numbers now:


Illinois:  (847) 458-8281


North Carolina: 


Charlotte Area: (704) 909-2792


RTP Area: (919) 827-4364

or send us an email at




Schaumburg/Hoffman Estates Area:


COMNet Group Inc.

2815 Forbs Avenue, Suite 107

Hoffman Estates, IL 60192


Oak Brook and Naperville Area:


COMNet Group Inc.

4320 Winfield Road, Suite 200

Cornerstone @Cantera

Warrenville, IL 60555


Gurnee/Waukegan/Grayslake/Lake Forest Area:


COMNet Group Inc.

100 Saunders Road, Suite 150

Lake Forest, IL 60045




University Executive Park Area



COMNet Group Inc.

301 McCullough Drive, Suite 400

Charlotte, NC 28262


Phone: (704) 909-2792




2530 Meridian Pkwy, Suite 200

Durham, NC 27713


Phone: (919) 827-4364




4208 Six Forks Road, Suite 1000

Raleigh, NC 27609


Phone: (919) 827-4364


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. 2005-2017 All Rights Reserved.