Unix – An Introduction
1. Unix Architecture
2. Comparative study between Windows & Unix to remember commands easily
3. Creating, Executing & Debugging shell scripts
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
Dataset/Database 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
7. Normalize
8. DeNormalize
Vectors & Records – Vector Types, Functions, Record Vector, Predefined vs User defined types
Dataset Components Contd.
1. Read/Write Excel
Internet Components
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
Phases & Checkpoints
Debugging – Tips & Tricks
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
Parameters – An Introduction, Types, Interpretation
Dynamic Programming – Parameter Definition Language & Meta Programming
Meta Programming Functions
Dynamic Programming Case study
1. To add/remove fields in record format
2. To create transformation rules
3. To create transformation rules & record format for flatten nested records
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 commands, Upstream/Downstream Analysis
Job Scheduling using Autosys
———-********———
Ab Initio training module (Old)
(Duration : 40 Hrs)
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
Input/ Output File/Table
Lookup File
Run SQL
Truncate Table
Update Table
Read Multiple files
Write Multiple files
Transform Functions – User Defined Vs Predefined
Sort Components – Hands on with real time retail warehouse scenario
Sort
Dedup Sorted
Find Splitters
Transform Components – Hands on with real time retail warehouse scenario
Reformat
Filter By Expression
Scan
Rollup
Join
Fuse