Boston Computer School

You are here:  Home » Courses » Datawarehousing » AB INITIO 

AB INITIO

Abinitio Course Contents

Introduction to Abinitio

Abinitio Architecture

Graph Programming

Introduction to .dat and .dml files


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

Course: AB INITIO

BCS Fees: $1500