TRAINING

Enroll Now

Ab Initio

Introduction to Data Warehousing Basis:-

• Ab Initio – An Introduction
• Ab Initio Products – An Overview
• Ab Initio Architecture
• Parallelism in Ab Initio
• GDE Overview
• Data Manipulation Language
• Different source system & record format types

Dataset Components – Hands on with the Files/Tables creation required for scenarios

• Input File
• Output File
• Read Multiple files
• Write Multiple files
• Lookup File
• Lookup template.

Database Components:-

• Input Table
• output Table
• Join with DB
• Truncate Table
• Update Table
• Run SQL

Sort Components – Hands on with real time retail warehouse scenario

• Sort
• Dedup Sorted
• Partition By Key & Sort
• Sort within Group

Transform Components – Hands on with real time retail warehouse:-

• Reformat
• Filter By Expression
• Scan
• Rollup
• Join
• Fuse
• Normalize
• Multi Reformat.
• Scan with Rollup.

Validate Component

• check order
• Compare records
• Compute Checksum
• Validate record

Partition Components – Hands on with real time retail warehouse scenario

• Partition By Key/Key & Sort
• Partition By Expression
• Partition By Range, Find Splitters
• Partition By Round Robbin

DePartiton Components – Hands on with real time retail warehouse

• Gather
• Merge
• Concatenate
• InterLeave Phases & Checkpoints Debugging – Tips & Tricks

Internet Components - Components usage provided in presentation:-

• FTP/SFTP TO
• FTP/SFTP FROM

Miscellaneous Components – Hands on with real time retail warehouse

• Generate Records
• Replicate
• Redefine
• Trash

Advanced topics:

• Parameters – An Introduction, Types,
• Interpretation
• PSET creation & execution
• Generic graphs, sub graphs
• Rollback & Recovery Mechanism
• Debugging techniques.
• Performance Tuning
• Useful Ab Initio commands – m_dump, m_eval, m_wc, m_cp,m_db , etc
• Introduction to EME – air commands,Code Check In/Check Out, Versioning & Tagging, Save Files.
• Working with Vectors
• Making and Breaking of vector.
• Conditional tab
• Phases and check points
• Start and end script
• SCD-2 structure
• CDC structure
• Conduct-it
• Continous components.