course img

AB Initio

Overview:

Ab Initio is works with the client-server model. It is a fourth generation data analysis, data manipulation, batch processing graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data.

Training Objectives of AB Initio:

The Main Objective of the SAP ABAP is to understand the key concepts in the Object OrientedProgramming is to integrate it into SAP ABAP to implement the various applications, and to understand the concepts of ABAP Objects and how to use them in Workbench tools to develop their own business applications and to enhance the Standard SAP Software to meet specific customer requirements.

Target Students / Prerequisites:

Students must have knowledge on SQL and PL/SQL and Basic Knowledge on UNIX Shell Scripting.

Course Details

Abinitio Course Contents

Introduction to Abinitio

Abinitio Architecture

Graph Programming

Introduction to .dat and .dml files

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
  • Matchsorted
  • 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