Welcome To Eazygurus

Abinitio

Course Name        :   DATA WAREHOUSING – AbInitio Online Training
Duration                 :  35 hrs

STUDENTS ENROLLED

    • Module I: Introduction to Ab Initio
      • Salient Features of Ab Initio
    • Module II: AbInitio Architecture
      • The Ab Initio Co-Operating System
      • Graphical Development Environment (GDE)
      • The Ab Initio Enterprise Meta-Environment (EME)
    • Module III: Sandbox and Parameter details
      • What is sandbox and its usage
      • Public and private parameters
      • Air Project parameter file
    • Module IV: Graph Programming
      • What is graph programming and basic parts of AbInitio graph building
      • What is the Anatomy of Running a Job
      • How do we Connect from GDE to the Server (Run ? Settings)
      • Broad classification of components
      • Editors in the GDE
      • XFR and its usage
    • Module V: Data Manipulation Language Overview (DML)
      • Record Formats
      • DML Expressions
      • Transform Functions
      • Key Specifies
    • Module VI: Components Dataset Components
      • Input File
      • Output File
      • Intermediate File
      • Lookup file
      • Transform Components
      • Filter by Expression
      • Dedup Sorted
      • Reformat
      • Aggregate
      • Scan
      • Rollup
      • Join
      • Match Sorted
      • Normalize
      • Denormalize Sorted
      • Partition Components
      • Broadcast
      • Partition by Key
      • Partition by Expression
      • Partition by Percentage
      • Partition by Range
      • Partition by Round-Robin
      • Partition with Load Balancing
      • De-partition Components
      • Concatenate
      • Gather
      • Interleave
      • Merge
      • Database Components
      • Input Table
      • Output Table
      • Run SQL
      • Truncate Table
      • Update Table
      • Join with DB
      • Sort Components
      • Sort
      • Sort Within Groups
      • Partition by Key & Sort
      • Miscellaneous Components
      • Redefine Format
      • Gather Logs
      • Replicate
      • Run Program
      • Thrash
    • Module VII: Parallelism
      • Component Parallelism
      • Pipeline Parallelism
      • Data Parallelism
      • Multifile and Multidirectories
    • Module VIII: AbInitio functions
      • AbInitio in-build functions
      • User defined functions
      • Lookup fuctions
    • Module IX: AbInitio Testing
      • Testing and Validation of Ab Initio Graphs using Validate Components
      • Compare Records
      • Validate Records
      • Generate Records
      • Compute Checksum
      • Compare Checksum
    • Module X: The Ab Initio Enterprise Meta>Environment (EME)
      • High level anatomy of the EME
      • Relation to sandbox environment
      • Checking in your sandbox
      • Checking out a graph or a sandbox
      • Locking in order to change an object
      • Tagging
      • Common projects
      • Dependency and Impact analysis
    • Module XI: Commands
      • air commands
      • m_commands
    • Module XII: AbInitio Best Practices and Performance Tuning
      • Phasing and Checkpoints
      • Sub-graphs
      • Serial Input Vs Multifile
      • Fan-In and Fan-Out
    • Module XIII : Parameter List
      • Defining variables in parameter list
      • Pset Definining variables in gragh design
      • Display Script
      • Wrapup Script
    • Module XIV : Enterprise scheduler
      • Plan
      • Conduct

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.