DESCRIPTION

The Ab Initio software is a fourth generation data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data.This tool also assures high data processing capability and provides speedups proportional to hardware resources available.

Ab Initio Training Advantages

  • Real-Time Project Training
  • Hands-on (Practical) Training
  • 100% Placement Support
  • 10+ Experienced Professionals
  • Student Referral Bonus

Explore the BEST concepts

The Ab Initio software is a Business Intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, Enterprise Meta>Environment, Data Profiler and Conduct>It. It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis.

AB INITIO Training Syllabus

  • Products of Ab-Initio Software Corporation
    • The Ab-Initio co operating system
    • Graphical development environment(GDE)
    • Enterprise Metadata Environment (EME)
    • Salient features of Ab-Initio
    • Understanding the high level Architecture
  • 1. What is the anatomy of running a job?
    • When we push run button
      • Deployment process
      • Host process creations
      • Agent process creation
      • Component process creation
      • Successful component termination
      • Agent termination
      • Host termination
      • Abnormal component termination
  • 2.How do we connect from G D E to the server (settings)
    • Host profile file (.aih)
    • Connection co operating system to the directory.

Ab-Initio introduction and advanced topics

  • 1. What is graph programming? What are the basic parts an Ab-Initio graph?
  • 2. Broad classification of components
    • Data set component
    • Program/computing components
  • 3. Data manipulating language (DML)
    • DML expressions
    • Transform functions
    • Key specifiers
  • 4. how do we build a basic Ab-Initio graph use file & DML ( record format file)
    • Data set components
      • input file
      • out put file
      • intermediate file
      • look up file
    • Editors in the G .D. E.
      • record format editor
      • expression editor
      • transform editor
      • key specifier editor
      • package editor
      • variables editor
      • sequence specifier editor
    • Transform functions
      • transform file (.xfr)
      • functions variables statements & rules
      • transform components multistage
    • Advanced components
      • filter by expression
      • Dedup sorted
      • Reformat
      • aggregate
      • scan
      • roll up
      • join
      • Match sorted
      • normalize
      • De-normalize sorted
  • Rep-Partitioning when & why Key out implementations
    • Sort components
      • Sort
      • Sort with in groups
      • Sample
      • Partition by key & sort
  • Look up datasets & dml look up functions
    • Partition components
      • Broadcast
      • Partition by key
      • Partition by expression
      • Partition by percentage
      • Partition by range
      • Partition by round bin
      • Partition with load balance
    • Multi-miles and multi-directives De-partition components
      • Concatenate
      • Gather
      • Interleave
      • Merge
    • What are parallelism types?
      • Components
      • Pipeline
      • Data
  • Working with database Introduction database Configuration files (.dbc)
    • Interactive database components (I.D.B)
      • Input table
      • Output table
      • Run sql
      • Truncate table
      • Update table
      • Join with DB
    • Miscellaneous components
      • Redefine format
      • Gather logs
      • Replicate
      • Run program
    • Deprecated components Find splitters
    • Compress components
      • Compress
      • Uncompress
      • Gzip
      • Gemzip
    • File transfer protocol (ftp) components
      • FTP from
      • FTP to
    • Testing & validation of Ab-Initio graph using components
      • Check order
      • Compare records
      • Validate records
      • Generate records
      • Generate random bytes
      • Compare check pointing
      • Phasing & check pointing
      • Reusability features
        • Sub graphs
        • Graph parameters
          • The Ab-Initio Enterprise Meta Environment
          • High level anatomy of the EME
          • Relation to sandbox environment
          • Checking out a graph or a sandbox
          • Locking in order to change an object
          • Tagging
          • Common projects
  • Dependency & impact analysis Performance tuning Ab-Initio graphs
    • What is good performance?
      • Going parallel
      • Serial inputs
      • Phases
      • Record formats & components
      • Memory usage
      • Various tips
    • Terminations
      • Agent
      • Component
      • Successful
      • Agent terminate
      • Host terminate
      • Abnormal comp on
ENROLL NOW DOWNLOAD COMPLETE SYLLABUS NOW