Welcome to Comnet Group Inc.

Courses

ETL (Ab Initio)

Course number: ETLABINITIO-CGI001

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

Course Outline
Ab Initio Architecture
  • Ab Initio Product Architecture
  • Client server Communication
  • Ab Initio – Process Flow
  • Co>operating System
  • Graphical Development Environment
Overview of Graph
  • The Graph Model
  • Parts of Typical Graph
  • Layout and Phase of Graph
  • Anatomy of a running job
Ab Initio Functions
  • Data Manipulation Language
  • Built-in Functions
  • Lookup File
  • Transform Functions
Basic Components
  • Reformat
  • Filter by Expression
  • Redefine Format
  • Replicate
  • Aggregate
  • Sort
  • Join
  • Dedup sorted
Partitioning and De-partitioning Components
  • Multi-files
  • Parallelism Concepts
    • Component Parallelism
    • Pipeline Parallelism
    • Data Parallelism
  • 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
  • Environment Set up
  • Sandbox & graph parameters
  • Private and Public Sandbox
  • Parameters sourcing technique
DB components & connectivity
  • Input Table
  • Output Table
  • Update Table
  • Truncate Table
  • Run SQL
  • DBC File
Advance components
  • Normalize
  • De-normalize Sorted
  • Meta Pivot
  • Multi Reformat
  • Inflate
  • Deflate
  • Assign Keys
  • Scan
  • Sort within Group
  • Match Sorted
  • Rollup
  • Conditional Components
  • Vectors
  • Custom Layouts
  • Control Statements (if, for, while, etc.)
Performance Tuning Tips
  • Performance Tuning Tips
EME basics
  • Check-in
  • Check-out
  • Tagging
MFS
  • MFS Commands
Debugging
  • Debugging
EME Administration
  • Features of EME
  • Sandbox and projects
  • Checking out graphs, files and projects
  • Checking in projects, sandboxes, graphs and files
  • Dependency analysis
  • Using web to access EME datastore
  • Reports, Versioning and Tagging
  • Air commands

Available Formats

Classroom
Live Online
Register