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) 909-2792

RTP Area: (919) 827-4364

 

South Carolina: 

Rock Hill : (803) 403-1970

 

Illinois:

Chicagoland Area: (847) 458-8281

 

or send us an email at info@comnetgroup.com.

LOCATIONS:

ILLINOIS:

 

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

 

 

NORTH CAROLINA:

 

University Executive Park Area

CHARLOTTE:

COMNet Group Inc.

301 McCullough Drive, Suite 400

Charlotte, NC 28262

Phone: (704) 909-2792

 

 

Cary/Raleigh Area - Weston Parkway

Raleigh/Cary/Durham:

COMNet Group Inc.

1000 Centregreen Way, Suite 200

Cary, NC 27513

Phone: (919) 827-4364

 

Durham:

COMNet Group Inc.

2530 Meridian Parkway, Suite 300

Durham, NC 27713

Phone: (919) 827-4364

 

 

SOUTH CAROLINA:

 

Rock Hill:

COMNet Group Inc.

331 East Main Street, Suite 200

Rock Hill, SC 29730

Phone: (803) 403-1970

 

ETL Development (Ab Initio)

Overview
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

 

Outline

 

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

ETLABINITIO-CGI001

Print Print | Sitemap
© COMNet GROUP INC. 2005-2017 All Rights Reserved.