|
Business Intelligence Training Overview
This course provides an excellent introduction to Ab Initio and also covers several advanced topics. A shorter version of the course is available without the advanced topics. The Implementation Methodology is based upon Enterprise Project Methodology with special attention to the capabilities that Ab Initio software provides for complex and/or data intensive applications and systems. This methodology has been built on various experiences utilizing Ab Initio software. Just as the functionality of Ab Initio software is ever expanding in meeting (and often exceeding) market need, so too does Ab Initio methodology.
What you will learn
- Ab Initio Server Hardware
- Ab Initio Installation
- Ab Initio Data Profiles
- Ab Initio File Systems and Heterogeneous Database Systems
- Ab Initio Data Integration Design Specifications
- Ab Initio Application Graphs
- Ab Initio Application Test Plan
- Ab Initio Graph Development Standards Checklist
- Ab Initio Lifecycle Migration
- Ab Initio Application Operations
Business Intelligence Audience
Developers with any RDBMS Applications.
Business Intelligence Prerequisites
- All the participants must be aware of any RDBMS activities along with its application.
- Data Warehousing Basics Knowledge.
- Prior Experience of any Ab-Initio Versions not required.
.
Business Intelligence Training Course duration
Six(6) Days Classroom & Lab Session(50% Lecture & 50% Hands-on Labs).
Four(4) Days Basics
Two(2) Days Advance
Business Intelligence Training Course outline
Day 1 & 2
Module I: Introduction to Ab Initio
- Salient Features of Ab Initio
Module II: AbInitio Architecture
- The Ab Initio Co-Operating System
- Graphical Development Environment (GDE)
- Intro to The Ab Initio Enterprise Meta-Environment (EME)
Module III: Sandbox and Parameter details
- What is sandbox and its usage
- Public and private parameters
Module IV: Graph Programming
- What is graph programming and basic parts of AbInitio graph building
- What is the Anatomy of Running a Job
- How do we Connect from GDE to the Server (Run ? Settings)
- Broad classification of components
- Editors in the GDE
- XFR and its usage
Day 3 & 4
Module V: Data Manipulation Language Overview (DML)
- Record Formats
- DML Expressions
- Transform Functions
- Key Specifiers
Module VI: Components · Dataset Components
- Input File
- Output File
- Intermediate File
- Lookup file
- Transform Components
- Filter by Expression
- Dedup Sorted
- Reformat
- Aggregate
- Scan
- Rollup
- Join
- Match Sorted
Day 5
- Partition Components
- Broadcast
- Partition by Key
- Partition by Expression
- Partition by Percentage
- Partition by Range
- Partition by Round-Robin
- Partition with Load Balancing
- De-partition Components
- Concatenate
- Gather
- Interleave
- Merge
- Database Components
- Input Table
- Output Table
- Run SQL
- Truncate Table
- Update Table
- Join with DB
Day 6
- Sort Components
- Sort
- Sort Within Groups
- Miscellaneous Components
- Redefine Format
- Gather Logs
- Replicate
- Run Program
- Trash
Module VII: Parallelism
- Component Parallelism
- Pipeline Parallelism
- Data Parallelism
- Multifile
Module VIII: AbInitio functions
- AbInitio in-build functions
- Lookup fuctions
Module IX: AbInitio Best Practices and Performance Tuning
- Phasing and Checkpoints
- Sub-graphs
- Serial Input Vs Multifile
- Fan-In and Fan-Out
|
