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