Introduction to Ab Initio

• why it is a market leader in ETl,
• key features in Ab initio
• where it is being used and how helps complex business

Introduction to Ab Initio

• CO>OP
• GDE
• EME
• CONTINUOUS process
• BRE

Understanding the High Level Architecture of Ab Initio

• Deployment Process
• Master Process Creation
• Agent Process Creation
• Component Process Creation
• Successful Component Termination
• Agent Termination
• Host Termination
• Establishing a connection from GDE to EME and EME to Co>OP and EME and GDE

Data Manipulation Language (DML)

• Record Formats
• DML Expressions
• Transform Functions

Data Manipulation Language (DML)

• Input File
• Output File
• Intermediate File
• Lookup file

Data Manipulation Language (DML)

• Transform File(.xfr)
• Functions, Variables, Statements & Rules

Transform Components

• Filter by Expression
• Dedup Sorted
• Reformat
• Aggregate
• Scan
• Rollup
• Join
• Match Sorted
• Normalize
• Denormalize Sorted

Partition

• 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

Working with Database

• Input Table
• Output Table
• Run SQL
• Truncate Table
• Update Table
• Join with DB

Miscellaneous Components

• Redefine Format
• Gather Logs
• Replicate
• Run Program
• Thrash

File Transfer Protocol (FTP) Components

• FTP From
• FTP To

Validate Components

• Check Order
• Compare Records
• Validate Records
• Generate Records
• Generate Random Bytes
• Compute Checksum
• Compare Checksum

Sort

• Sort
• Sort within Groups
• Partition by Key & Sort

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
• Phasing and check pointing
• Real time scenarios