Ab Initio

Ab Initio Training 

Introduction :

Ab Initio means “ Starts From the Beginning”. Ab-Initio software works with the client-server model.

The client is called “Graphical Development Environment” (you can call it GDE). It resides on user desktop.The server or back-end is called Co-Operating System”. The Co-Operating System can reside in a mainframe or unix remote machine.

 The Ab-Initio code is called graph ,which has got .mp extension. The graph from GDE is required to be deployed in corresponding .ksh version. In Co-Operating system the corresponding .ksh in run to do the required job.

Course Description:

Introduction to Abinitio software

Ab initio Architecute

  • Understanding GDE
  • Understanding Co-op System
  • Understanding EME/Application hub

Understanding Host connection settings

  • Configure host settings

Understanding Abinitio Jobs/ Graphs

  • Basics of Graphs
  • Building and executing graphs
  • Understanding Sandboxes/Projects

Understanding components inside a graph

  • Record formats, DML, Transform functions, Key specifiers
  • Dataset components/ Table components/Program components
  • Layout
  • Parameters
  • Validating the graphs and understanding the error messages
  • Component Overview-Editors
    • Record Format Editors
    • Expression Editors
    • Transform Editors
    • Key Spefifier Editors
    • Package Editiors
    • Variable Editors

Component Overview-Dataset components

  • Input file
  • Output File
  • Intermediate file
  • Lookup files and Lookup Functions

Component Overview-Dataset components

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

Understanding partitioning Concepts and mutifiles

  • Understanding Multifiles
  • Understanding Parallelism
    • Data Parallelism
    • Component Parallelism
    • Pipeline parallelism

Component Overview-Partition components

  • Broadcast
  • Partition by key
  • Partition by expression
  • Partition by round robin
  • Partition by range
  • Partition by load balance

Component Overview-Departition components

  • Gather
  • Concatenate
  • Interleave
  • Merge

Component Overview-Database Components, dbc file configuration

  • Understanding database configuration
  • Input table
  • Output table
  • Run SQL
  • Truncate Table
  • Update Table
  • Join with DB

Component Overview- Miscelleneous Components

  • Redefine format
  • Gather Logs
  • Replicate
  • Run Program
  • Trash

Component Overview- Validate Components

  • Check Order
  • Compare Records
  • Validate Records
  • Generate Record
  • Create Data
  • Compute Checksum

Understanding Performance Tuning

  • Component Folding

Additional Graph concepts

  • Tagging
  • Branching
  • Checkin-Checkout
  • Locking
  • Common projects
  • Dependancy analysys/Impact analysys
  • Generic Graphs/Reusable Graphs
  • Conditional components
  • Concept of Phases and check point

Understanding Plans/ConductIT

Understanding Continuous Flows

Understanding various command line options/ configuration Variables

  • m commands
  • air commands
  • configuration variables
  • Environment variables



Comments are closed