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 info@comnetgroup.com.

LOCATIONS:

ILLINOIS:

 

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

 

NORTH CAROLINA:

 

University Executive Park Area

CHARLOTTE:

 

COMNet Group Inc.

301 McCullough Drive, Suite 400

Charlotte, NC 28262

 

Phone: (704) 909-2792

 

DURHAM:

 

2530 Meridian Pkwy, Suite 200

Durham, NC 27713

 

Phone: (919) 827-4364

 

RALEIGH:

 

4208 Six Forks Road, Suite 1000

Raleigh, NC 27609

 

Phone: (919) 827-4364

 

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.