|
In this course participant’s work through a number of instructor led hands-on exercises. Participants also complete a set of integration exercises in which business oriented world problems are answered by building Ab Initio graphs.
After working with Ab Initio in a development environment, users may wish to get more in depth training in several areas. This course is designed to deliver instructions in a variety of advanced topics too. We can work with you to tailor this course to meet your needs.
Module I: Introduction to Ab Initio. Operating Systems & Hardware Platforms that it supports
Module II: Products of Ab Initio Software Corporation
- The Ab Initio Co>Operating System
- Graphical Development Environment (GDE)
- The Ab Initio Enterprise Meta>Environment (EME)
Module III: Salient Features of Ab Initio
Module IV: Understanding the High Level Architecture of Ab Initio
What is the Anatomy of Running a Job? What happens when we push the ‘Run’ Button?
- Deployment Process
- Host Process Creation
- Agent Process Creation
- Component Process Creation
- Successful Component Termination
- Agent Termination
- Host Termination
- Abnormal Component Termination
How do we Connect from GDE to the Server (Run ? Settings)
- Host Profile File (.aih)
- Connection, Co-Operating System, Shell & Host Directory
What is Graph Programming? What are the basic parts of an Ab Initio Graph?
Broad Classification of Components
- Dataset Components
- Program / Computing Components
Data Manipulation Language (DML)
- Record Formats
- DML Expressions
- Transform Functions
- Key Specifiers
How do we build a basic Ab Initio Graph? Using .dat(Data File) & .dml(Record Format File)
Dataset Components
- Input File
- Output File
- Intermediate File
- Lookup file
Editors in the GDE
- Record Format Editor
- Expression Editor
- Transform Editor
- Key Specifier Editor
- Package Editor
- Variables Editor
- Sequence Specifier Editor
Transform Functions
- Transform File(.xfr)
- Functions, Variables, Statements & Rules
Transform Components - Multistage and Advanced Components
- Filter by Expression
- Dedup Sorted
- Reformat
- Aggregate
- Scan
- Rollup
- Join
- Match Sorted
- Normalize
- Denormalize Sorted
Lookup Dataset’s & DML Lookup Functions
Partition Components
- Broadcast
- Partition by Key
- Partition by Expression
- Partition by Percentage
- Partition by Range
- Partition by Round-Robin
- Partition with Load Balancing
Multifiles and Multidirectories
De-partition Components
- Concatenate
- Gather
- Interleave
- Merge
What is Parallelism - Types
- Component ||’sm
- Pipeline ||’sm
- Data ||’sm
Repartitioning – When & Why
Layout Implications
- Sort
- Sort within Groups
- Sample
- Partition by Key & Sort
- Check point Sorted
Working with Database’s. Introduction Database Configuration File (.dbc)
Interactive Database Components (IDB)
- Input Table
- Output Table
- Run SQL
- Truncate Table
- Update Table
- Join with DB
Miscellaneous Components
- Redefine Format
- Gather Logs
- Replicate
- Run Program
- Thrash
Deprecated Components
Compress Components
- Compress
- Uncompress
- GZip
- GUnzip
File Transfer Protocol (FTP) Components
Testing and Validation of Ab Initio Graphs using Validate Components
- Check Order
- Compare Records
- Validate Records
- Generate Records
- Generate Random Bytes
- Compute Checksum
- Compare Checksum
Phasing & Checkpointing
Reusability Features
- Sub graphs
- Graph Parameters
The Ab Initio Enterprise Meta>Environment(EME)
- High level anatomy of the EME
- Relation to sandbox environment
- Checking in your sandbox
- Checking out a graph or a sandbox
- Locking in order to change an object
- Tagging
- Common projects
- Dependency and Impact analysis
Performance Tuning Ab Initio Graphs
- What is Good Performance?
- .. Going Parallel
- ... Serial Inputs
- ... Phases
- ... Record Formats and Components
- ... Memory Usage
- ... Various Tips
Duration:
- 36-38 Hours. 3 days per week. 6-7 hours per day.
For more details click here - Locate a center |
