AB INITIO

AB INITIO TRAINING

AB INITIO TRAINING COURSE CONTENT


     Data Warehousing Concepts

  • Introduction to Abinitio
  • AbInitio detailed architecture
  • Features of Ab Initio Graph, Component, Ports, DML
  • Introduction to .dat and .dml files
  • Ports available on overall components

TYPES Partition Components available

  • 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