Ab Initio Certification Training

✔ Unix Architecture
✔ Unix basic commands

✔ ls, cp, mv, rm, mkdir, rmdir, cat, find, sed, awk, grep, egrep, ps, top, head, tail, gzip, gunzip, chmod, vi editor commands, more, nohup

✔ Overview of Datawarehousing
✔ Difference between OLTP & OLAP
✔ Dimension table
✔ Fact table
✔ Star schemas
✔ Snowflake schemas
✔ Datamart
✔ Galaxy Schemas
✔ Confirmed dimension tables
✔ Degenerate dimension tables
✔ Junk dimension tables
✔ Factless fact tables
✔ Slowly changing dimensions (SCD)

✔ Overview of AbInitio features
✔ Ab Initio Architecture
✔ Anatomy of a Job execution
✔ GDE overview
✔ GDE to Host profile creation
✔ DML
✔ About Datasets, Tables
✔ Building and execution of the graph

✔ Sort
✔ Sort within groups
✔ Partition by key and sort

✔ Reformat
✔ Join
✔ Rollup
✔ Scan
✔ Normalize
✔ Fuse
✔ Scan with Rollup
✔ Dedup Sorted
✔ Filter by Expression
✔ Multi Reformat

✔ Project structure
✔ Sandbox structure
✔ Sandbox parameters
✔ Data directories creation
✔ Abinitiorc file
✔ Sandbox setup
✔ Private projects
✔ Public projects
✔ Difference between Private and public projects
✔ Check-in through GDE
✔ Check-out through GDE
✔ Check-in through command level
✔ Check-out through command level

✔ Multi files
✔ Layout
✔ Parallelism Techniques

✔ Pipeline Parallelism
✔ Component Parallelism
✔ Data Parallelism

✔ Phases and checkpoints
✔ Rollback Recovery mechanism

✔ Input file
✔ Output file
✔ Intermediate file
✔ Read excel
✔ Write excel
✔ Lookup Template

✔ Input Table
✔ Output Table
✔ Update Table
✔ Run SQL
✔ Truncate table
✔ Join with DB
✔ Call stored procedure

✔ Overview of Lookups
✔ Static Lookups
✔ Dynamic lookups
✔ lookup() function
✔ lookup_local() function
✔ lookup_count() function
✔ lookup_next() function
✔ lookup_add() function

✔ Partition by key
✔ Partition by Round Robin
✔ Partition by expression
✔ Partition by percentages
✔ Partition with load balance
✔ Broadcast

✔ Gather
✔ Interleave
✔ Merge
✔ Concatenate

✔ Compress
✔ Decompress
✔ Deflate
✔ Inflate
✔ ftp from
✔ ftp to

✔ Validate
✔ Check order
✔ Generate records
✔ Create data
✔ Compute checksum
✔ Compare checksum
✔ Compare records

✔ Replicate
✔ Gather logs
✔ Redefine format
✔ Run program

✔ Air commands
✔ Tagging commands

✔ SCD type-1 implementation
✔ SCD type-2 implementation

✔ User-defined sandbox level parameters
✔ Parameters Introduction and interpretation
✔ Graph level parameters
✔ Generic graphs
✔ Psets
✔ Plans
✔ Conditional Components
✔ Optimization Techniques
✔ Metaprogramming
✔ PDL
✔ Debugging Techniques
✔ End to End SDLC flow
✔ DBC file creation and generalizing to various environments