Ab Initio Training

Ab Initio Syllabus

Batch vs Continuous

Different products of Ab initio

  • Conduct>IT
  • Query > IT
  • Express>IT
  • BRE

Common Terminology Used in Ab initio

  • Graph (map)
  • Subgraph
  • Plan
  • DML
  • xfer
  • pset
  • GDE
  • Sandbox
  • Checking
  • Checkout
  • Lock
  • GDE Configuration - Host Connection

EME

  • Introduction
  • Architecture of EME and Coops

Components

Table

  • Input Table
  • Output Table
  • Update Table
  • Multi-Update
  • Truncate Table

File

  • Input File
  • Output File
  • Intermediate File
  • Lookup File
  • Read Multiple Files
  • Write Multiple Files
  • Compression via Flow - Deflate and Inflate -- to compress and decompress the files

Parallelism

  • Serial and Parallel
  • Types of Parallelism
  • Data
  • Component
  • Pipeline

Multi-file system creation commands

  • How to view the multi-file data
  • How to convert multi-file into Serial File

Partitioning

  • Partition by Key
  • Partition by Expression
  • Partition by Round Robin
  • Broadcast

Departitioning

  • Merge
  • Gather
  • Concatenate
  • Interleave
  • Transform
  • Reformat
  • Filter by Expression
  • Rollup
  • Scan
  • Sort
  • Sort within Group
  • Dedup Sorted
  • Normalize
  • Run Program
  • Run SQL
  • Redefine
  • Trash
  • Replicate
  • Leading Record
  • Replicate
  • Send Message
  • Write Excel
  • Read Excel
  • Write XML
  • Read XML
  • XML Split

Join

Types

Explicit

  • Inner Join
  • Full outer Join

CDC - Change Data Capture

  • Type 1
  • Type 2
  • Type 3

Validate

  • Validate
  • Generate Records

Parameters

  • Different Interpretation of Parameters
  • PDL, $, ${}, Shell
  • PSET Creation and purpose

Generic Details in GDE

Condition Tab

Phase and Checkpoints

AIR Utility commands

Air

  • m_db unload
  • m_dump

Ab Initio Functions

  • next_in_sequence()
  • string_upcase()
  • string_downcase()
  • string_filter()
  • string_filter_out()
  • string_lrtrim()
  • decimal_strip()
  • string_substring()
Quick Enroll