Abinitio Training Online



Datawarehousing Concepts

Introduction to Ab Initio. Operating Systems & Hardware Platforms that it supports

Products of Ab Initio Software Corporation

The Ab Initio Co>Operating System

Graphical Development Environment (GDE)

The Ab Initio Enterprise Meta>Environment (EME)

Salient Features of Abinitio Online Training



Understanding the High Level Architecture of Ab Initio

What is the Anatomy of Running a Job? What happens when we push the ‘Run’ Button?

Deployment Process

Host Process Creation

Agent Process Creation

Component Process Creation

Successful Component Termination

Agent Termination

Host Termination

Abnormal Component Termination

How do we connect from GDE to the Server (RunSettings)

Host Profile File (.aih)

Connection, Co-Operating System, Shell & Host Directory

What is Graph Programming? What are the basic parts of an Ab Initio Graph?

Data Manipulation Language (DML)

Record Formats

DML Expressions

Transform Functions

Key Specifiers

How do we build a basic Ab Initio Graph? Using .dat(Data File) & .dml(Record Format File)

What is Parallelism – Types

Component Parallelism

Pipeline Parallelism

Data Parallelism

Sandbox – Types

Private Sandbox

Public Sandbox

Editors in the GDE

Record Format Editor

Expression Editor

Transform Editor

Key Specifier Editor

Package Editor

Variables Editor

Sequence Specifier Editor

Dataset Components of Abinitio Online Classes

INPUT FILE

OUTPUT FILE

INTERMEDIATE FILE

LOOKUP FILE

LOOKUP TEMPLATE

BLOCK-COMPRESSED LOOKUP TEMPLATE

Transform Components – Multistage and Advanced Components

DEDUP SORTED

FILTER BY EXPRESSION

JOIN

MULTI REFORMAT

NORMALIZE

REFORMAT

ROLLUP

SCAN

SCAN WITH ROLLUP

Partition Components

BROADCAST

PARTITION BY KEY

PARTITION BY EXPRESSION

PARTITION BY PERCENTAGE

PARTITION BY RANGE

PARTITION BY ROUND-ROBIN

De-partition Components

CONCATENATE

GATHER

INTERLEAVE

MERGE

Miscellaneous Components

REDEFINE FORMAT

GATHER LOGS

REPLICATE

RUN PROGRAM

TRASH

Compress Components

COMPRESS

UNCOMPRESS

DEFLATE

INFLATE

Interactive Database Components (IDB)

INPUT TABLE

OUTPUT TABLE

RUN SQL

UPDATE TABLE

JOIN WITH DB

Sort Components : Abinitio Online Training



SORT

SORT WITHIN GROUPS

SAMPLE

PARTITION BY KEY AND SORT

Validate Components

CHECK ORDER

COMPARE RECORDS

CREATE DATA

GENERATE RECORDS

VALIDATE RECORDS

Working with Database’s. Introduction Database Configuration File (.dbc)

Lookup Functions

Lookup Local

Lookup Count

Lookup First

Lookup Last

Lookup Next

StringFunctions

String_char

String_concat

String_filter

String_filter_out

String_length

String_lrepad

String_rindex

String_substring

String_upcase

String_split

String_length

Multifiles and Multidirectories(MFS)

Phasing &Checkpointing

Reusability Features of Abinitio Online Training

Sub graphs

Graph Parameters

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

Dependency and Impact analysis

Implementation of SCD’s(Slowly Changing Dimensions)

SCD-Type1

SCD-Type2

SCD-Type3

Advanced Features

Debugging Techniques

Plan>It

Performance Tuning

PSETS

Abinitio Online Training in Hyderabad,India