Training Requirements
Student requirements:
ü Student should have 1~2 year IT related experience.
ü Student background with Business and IT degree are desired.
Students at end of this class will be able to:
ü Learn implementation by building and support Abinitio data processing application
ü Basic troubleshooting skill on performance of application
Lesson Purpose:
ü Let student know why need take this training and Enjoy a distance and maximize Abinitio investment.
Facility requirement:
ü GDE installed on client
ü Co-operation system installed on Server
ü Student has exercise environment
Overview
The Ab Initio software is a fourth generation data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing product. Ab Initio is the best extract, transform, and load (ETL) tool.
Below topics will be covered by this training.
ü Introduction
ü Architecture
ü GDE(Graphical Development Environment)
ü Components
ü Commands
ü Performance Tuning
ü Exercise
Introduction
ü What is data warehouse
ü Data Warehouse Architecture
ü ETL process
ü Why Abinitio
Architecture
ü What does Abinitio mean
ü Product Architecture
ü Co>Operation System
ü Development Ecosystem
GDE(Graphical Development Environment)
ü What looks like
ü Component library
ü Customer library
Components
ü Input Components
ü Output Components
ü Reformat
ü Join
ü Sort
ü Scan
ü Rollup
ü XML
ü Lookup
Commands
ü m_dump
ü m_env
Performance Tuning
ü General rules
ü Parallel of Processing
ü How many ways parallel should use
ü MFS
Exercise
ü Name Parsing
ü Globally Unique Key
ü Normalize
ü Partition
ü Dedup
ü Upsert
ü Lookup File
ü Multifiles
ü Layout
ü Benchmarking
ü Debug