AB INITIO

Description

AB INITIO tool is a fourth-generation batch-processing application, data manipulation, and data analysis with a graphical user interface (GUI).

Prerequisite:

• Basic Programming
• UNIX
• SQL

Data Warehousing Basics

• Technology Life cycle
• OLTP OLAP Based Systems
• Data warehouse DataMart
• ETL Architecture
• Dimension & Facts
• Slowly changing Dimensions

Unix commands required for working on Ab Initio Co Op installed machine –

• An Introduction
• Ab Initio Products – An Overview Ab Initio Architecture Parallelism
• GDE Overview
• Establishing Connection from GDE to Co Op Data Manipulation Language
• Different source system & record format types

Data set Components used for Data Extraction/Loading –

Hands on with the Files/Tables creation required for scenarios to build retail warehouse

• Input/output File/Table
• Lookup File
• Run SQL
• Truncate Table
• Update Table

Transform Functions –

User Defined Vs Predefined

Sort Components –

Hands on with mapping documents to build retail warehouse

• Sort
• Dedup Sorted
• Find Splitters

Transform Components –

Hands on with mapping documents to build retail warehouse

• Reformat
• Filter By Expression
• Join
• Fuse

Transform Components–

Hands on with mapping documents to build retail warehouse

• Scan
• Rollup
• Normalize

Parameters –

• An Introduction
• Types
• Interpretation
• Parameter evaluation

Change Data Capture & Slowly changing dimensions Implementation Phases & Checkpoints

Debugging –

• Tips & Tricks Performance Tuning
• Multi-file System

Partition Components –

Hands on with mapping documents to build retail warehouse

• Partition By Key/Key & Sort
• Partition By Expression
• Partition By Range, Find Splitters
• Partition By Round Robin

DE-Partition Components –

Hands on with mapping documents to build retail warehouse

• Gather
• Merge
• Concatenate
• Interleave
• Generic graphs
• Components PSET creation & execution

 Useful Ab Initio commands –

• m_dump
• m_eval
• m_wc
• m_cp, etc

Introduction to EME –

• Project Types (Public/Private)
• Public Projects (stdenv/abenv)
• Project Overrides
• Code Check In/Check Out
• Versioning & Tagging
• Save Files & Promotion using air commands Rollback & Recovery Mechanism

Software’s required –

• Ab Initio GDE
• Co Op
• EME – Minimum 10/2.10

Outcome –

• Associates can design/develop ETL solutions using Ab Initio products suite as an individual/performer in a
• Analyze the data quality issues, fix & implement development/enhancements projects
• Associates can develop framework driven reusable solutions efficiently thereby reducing the turnaround

Please Visit AB INITIO Official Site: