AB Initio Training In Chennai

Vikapri course png
About AB Initio

Ab Initio is an ELT software deals with Business Intelligence and Data processing Platform. It involves integration, validation, profiling and management of data.

As a parallel process to ELT, it has a graphical user interface-based for data management and analysis. There is lots of demand for Ab Initio developers as it is considered an emerging software in the market.

We provide the best AB INITIO Training In Chennai, in which you get knowledge in this course with one-on-one training sessions by Experts.

Course Contents - AB Initio

AB Initio Training Introduction to Data warehousing and BI
  • Data warehouse concept
  • Architecture of DWH
  • Design robust DWH for organization
  • Explain of Extract, Transform and Load (ETL)
  • Staging table concept and design
  • Type of Dimensional tables
  • Type of FACTS tables
  • Explain of Data lake and Data Mart
  • ETL product in markets
Introduction to Ab Initio Product
  • Overview of Ab Initio Software
  • Versioning and feature of this software
  • Basics of Ab Initio
Ab Initio Architecture
  • Architecture of Ab Initio
  • Component in Ab Initio
  • Understanding GDE
  • Understanding Co-op System
  • Understanding EME/Application hub
  • Usage of .dat and .dml files
Host Connection Settings
  • Configure host settings to connect components
Ab Initio Jobs/ Graphs
  • Basics of Graphs
  • Build and execute graphs
  • Understanding Sandboxes environments
Components in a graph
  • Overview of Components
  • Basic concept on Components
  • Record formats, DML
  • Transform functions
  • Dataset components/ Table components/Program components
  • Explain of Layout
  • Parameters
  • Validate the graphs and explain the error messages
  • Component Overview-Editors
  • Record Format Editors
  • Expression Editors
  • Explain on Transform Editors
  • Key Specifier Editors
  • Package editors
  • Variable Editors
Dataset Components
  • Input file and Output File
  • Intermediate file
  • Lookup files and Lookup Functions
  • Filter by expression
  • De-dup sorted
  • Reformat
  • Aggregate functions
  • Explain on Scan
  • Rollup
  • Join and merge
  • Match sorted
  • Normalize to use on design
  • De-normalize Sorted
Partitioning Concepts and multi-files
  • Understanding Multifiles
  • Understanding Parallelism
  • Data Parallelism
  • Component Parallelism
  • Pipeline parallelism
Partition Components
  • Broadcast
  • Partition by key
  • Partition by expression
  • Partition by round robin
  • Partition by range
  • Partition by load balance
De-partition Components
  • Gather
  • Concatenate
  • Interleave
  • Merge
Database Components, dbc file configuration
  • Understanding database configuration
  • Create and Update table
  • DML operation on table
  • Input and Output table
  • Run SQL
  • Truncate Table
  • Update Table
  • Join and merge Database
Miscellaneous Components
  • Redefine format
  • Gather Logs
  • Replicate
  • Run Program
  • Trash
Validate Components
  • Overview of Validation
  • Verify Order
  • How to Compare Records
  • Validate Records against Schema
  • Generate Records
  • Create Sample Data
  • Checksum operation
Graph concepts
  • Tagging
  • Branching
  • Check-in and Check-out
  • Locking
  • Common projects
  • Dependency analysis/Impact analysis
  • Generic Graphs/Reusable Graphs
  • Conditional components
  • Concept of Phases and check point
Command Line Configuration Options
  • Overview of Command Line Command
  • Usage of m commands
  • air commands
  • How to use configuration variables
  • Environment variables