Ab Initio

Course: AB Initio 

Introduction to Abinitio

Ab Initio high level architectureSalient  

features of Ab Initio

Graph, Component, Port, DML etc……

Introduction to .dat and .dml files

Different ports available on overall components

TYPES Partition Components

• Braod Cast
• Partition by Expression
• partition by range
• partition by community
• partition by percentage
• partition by Round Robin

Departition Components

• Concatenate
• Gather
• Interleave
• Merge

Multifile System(MFS)

Types of parallelism 

Layouts

• Sort Components
• Sort
• Sort with in groups
• Sample
• Partition by key and sort

Transform Components

• Filter by expression
• Aggregate
• Scan
• Rollup
• Denormalize Sorted
• Normalize
• Reformat
• Match sorted
• Dedup sorted

Working with Databases

• Database components
• Run SQL
• Input Table
• Output Table
• Truncate Table
• Update table

Phase and check Points

Miscellaneous component

• Gather logs
• Run program
• Redefine format
• Trash
• Replicate

Dataset Components

• Input File
• Output File
• Lookup File
• Intermediate File

FTP Components

• FTP From
• FTP To

Compress Components

• Compress
• Uncompress
• Gzip
• Gunzip

Validate Component

• Check Order
• Generate Records
• Generate Random bytes
• Compare Records
• Compute Check Sum
• Compare Check Sum

Translate components

• Record XML
• Write XML

Project and Sandbox

Performance Tuning