Best Online IT Courses in Delaware | Online IT Training | Cyber Ascent

Abinitio ETL

Introduction to Data warehousing and BI

  • Data warehouse concept
  • Architecture of DWH
  • Design robust DWH for organization
  • Explain of Extract, Transform and Load (ETL)
  • Staging table concept and design
  • Type of Dimensional tables
  • Type of FACTS tables
  • Explain of Data lake and Data Mart
  • ETL product in markets

AB Initio Training Introduction to Ab Initio Product

  • Overview of Ab Initio Software
  • Versioning and feature of this software
  • Basics of Ab Initio

AB Initio Training Ab Initio Architecture

  • The architecture of Ab Initio
  • Components in Ab Initio
  • Understanding GDE
  • Understanding Co-op System
  • Understanding EME/Application hub
  • Usage of .dat and .dml files

AB Initio Training Host Connection Settings

  • Configure host settings to connect components

AB Initio Training Ab Initio Jobs/ Graphs

  • Basics of Graphs
  • Build and execute graphs
  • Understanding Sandboxes environments

AB Initio Training Components in a graph

  • Overview of Components
  • The basic concept of Components
  • Record formats, DML
  • Transform functions
  • Dataset components/ Table components/Program components
  • Explain of Layout
  • Parameters
  • Validate the graphs and explain the error messages
  • Component Overview-Editors
  • Record Format Editors
  • Expression Editors
  • Explain on Transform Editors
  • Key Specifier Editors
  • Package editors
  • Variable Editors

AB Initio Training Dataset Components

  • Input file and Output File
  • Intermediate file
  • Lookup files and Lookup Functions
  • Filter by expression
  • De-dup sorted
  • Reformat
  • Aggregate functions
  • Explain on Scan
  • Rollup
  • Join and merge
  • Match sorted
  • Normalize to use on the design
  • De-normalize Sorted

AB Initio Training Partitioning Concepts and multi-files

  • Understanding Multi files
  • Understanding Parallelism
  • Data Parallelism
  • Component Parallelism
  • Pipeline parallelism

AB Initio Training Partition Components

  • Broadcast
  • Partition by key
  • Partition by expression
  • Partition by round-robin
  • Partition by range
  • Partition by the load balance

AB Initio Training De-partition Components

  • Gather
  • Concatenate
  • Interleave
  • Merge

AB Initio Training Database Components, dbc file configuration

  • Understanding database configuration
  • Create and Update table
  • DML operation on table
  • Input and Output table
  • Run SQL
  • Truncate Table
  • Update Table
  • Join and merge Database

AB Initio Training Miscellaneous Components

  • Redefine format
  • Gather Logs
  • Replicate
  • Run Program
  • Trash

AB Initio Training Validate Components

  • Overview of Validation
  • Verify Order
  • How to Compare Records
  • Validate Records against Schema
  • Generate Records
  • Create Sample Data
  • Checksum operation

AB Initio Training Graph concepts

  • Tagging
  • Branching
  • Check-in and Check-out
  • Locking
  • Common projects
  • Dependency analysis/Impact analysis
  • Generic Graphs/Reusable Graphs
  • Conditional components
  • Concept of Phases and checkpoint

AB Initio Training Command Line Configuration Options

  • Overview of Command-Line Command
  • Usage of m commands
  • air commands
  • How to use configuration variables
  • Environment variables

AB Initio Training Best Practices on AB Initio


Quick Enroll