LiveZilla Live Help
India : +91 996 395 7366
USA : +1 214 347 4655
facebook twitter linkedin Google +

Ab Initio

Ab Initio Online Training

The Ab Initio software is a fourth generation data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing product which is commonly used toextract, transform, and load (ETL) data. The Ab Initio product also allows for processing of real-time data.

Ab Initio has a Two Tier Architecture with a Graphical Development Environment(GDE) and the Co>Operating system coupled together to form a client-server like architecture.

Introduction to Abinitio

Ab Initio high level architectureSalient  
features of Ab Initio
Graph, Component, Port, DML etc……
Introduction to .dat and .dml files
Different ports available on overall components
TYPES Partition Components
  • Braod Cast
  • Partition by Expression
  • partition by range
  • partition by community
  • partition by percentage
  • partition by Round Robin

Departition Components

  • Concatenate
  • Gather
  • Interleave
  • Merge

Multifile System(MFS)

Types of parallelism 

Layouts

  • Sort Components
  • Sort
  • Sort with in groups
  • Sample
  • Partition by key and sort

Transform Components

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

Working with Databases

  • Database components
  • Run SQL
  • Input Table
  • Output Table
  • Truncate Table
  • Update table

Phase and check Points

Miscellaneous component

  • Gather logs
  • Run program
  • Redefine format
  • Trash
  • Replicate

Dataset Components

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

FTP Components

  • FTP From
  • FTP To

Compress Components

  • Compress
  • Uncompress
  • Gzip
  • Gunzip

Validate Component

  • Check Order
  • Generate Records
  • Generate Random bytes
  • Compare Records
  • Compute Check Sum
  • Compare Check Sum

Translate components

  • Record XML
  • Write XML

Project and Sandbox

Performance Tuning