AB Initio

Week-1

Introduction to Abinitio, comparison of Abinitio with other ETL Tools.
Introduction to a Datawarehouse
Datawarehouse Architecture
Types of DatawareHouse Approaches
Facts & Dimensions
Modelling concepts Introduction
Types of schemas
Abinitio concepts
Abinitio Architecture
Relationship Between GDE, Co>op, EME
Introduction to Sandbox

Week-2

Creating a Sandbox
Relationship between Sandbox and EME
Air commands
Check-in, check-out & locking
Introduction to Graph Programming
Components Introduction
Types of Various Components
Partition components
Partition components
Departition Components like: Gather, concatenate, Merge & Interleave
Assignment 1

Week-3

Validate components
a.Checkorder
b.compare records
c.Checksum
d.Computechecksum
e.Validate records
Translate components
a.Read XML & Write XML
b.Read EXCEL & Write Excel
FTP Components
Compress Components
Sort Components
Transform Components:
a. Dedup- Sort
b. Filter By Expression components and its internal parameters functions
Reformat component and its Parameters

Week-4

String Functions
Executing all the string functions by using various transform components
Transform components
a.Aggregate components and its parameters
b.Rollup Components and its parameters
c.Various Aggregation functions in rollup components
d. Scan component and its parameters
Join components and its parameters
Fuse Component and its internal parameters
Normalize Component
Assignment 2

Week-5

De-Normalize Sorted Component
Match Sorted Components
Miscellaneous Components
Introduction to Database Components
Creating .dbc file
Different types of Orainterfaces in Database components

Week-6

Continuous Components
New Components introduced in the latest version of Abinitio V3.0.5
Hands on Project
Interview related questions discussion
Mock interview session