Abinitio Online for advanced learners by BoundTech Solutions

AB INITIO COURSE COVERAGE
No of Hours : 40
Introduction to Data Warehousing Basis
Ab Initio An Introduction
Ab Initio Products An Overview
Ab Initio Architecture
Parallelism in Ab Initio
GDE Overview
Establishing Connection from GDE to Co Op
Data Manipulation Language
Different source system & record format types
Data set Components Hands on with the Files/Tables creation required for scenarios
1. Input/ Output File/Table
2. Lookup File
3. Run SQL
4. Truncate Table
5. Update Table
6. Read Multiple files
7. Write Multiple files
Transform Functions User Defined Vs Predefined
Sort Components Hands on with real time retail warehouse scenario
1. Sort
2. Dedup Sorted
3. Find Splitters
Transform Components Hands on with real time retail warehouse scenario
1. Reformat
2. Filter By Expression
3. Scan
4. Rollup
5. Join
6. Fuse
044 42 63 42 42
9500053050
7. Normalize
8. DeNormalize
Multifile System
Partition Components Hands on with real time retail warehouse scenario
1. Partition By Key/Key & Sort
2. Partition By Expression
3. Partition By Range, Find Splitters
4. Partition By Round Robbin
DePartiton Components Hands on with real time retail warehouse scenario
1. Gather
2. Merge
3. Concatenate
4. InterLeave
Phases & Checkpoints
Debugging Tips & Tricks
Dataset Components Contd. Components usage provided in presentation
1. Read/Write Excel
Internet Components - Components usage provided in presentation
1. FTP/SFTP TO
2. FTP/SFTP FROM
Miscellaneous Components Hands on with real time retail warehouse scenario
1. Generate Records
2. Create Data
3. Replicate
4. Redefine
5. Run Program
6. Trash
Parameters An Introduction, Types, Interpretation
PSET creation & execution
Generic graphs, components
Introduction to wrappers
Rollback & Recovery Mechanism
Performance Tuning
Useful Ab Initio commands m_dump, m_eval, m_wc, m_cp,m_db , etc
Introduction to EME Code Check In/Check Out, Versioning & Tagging, Save Files & Promotion
using air commandsJob Scheduling
044 42 63 42 42
9500053050