Abinitio ETL

Course Overview:

AbInitio Component Library is a reusable software module for sorting, data transformation, and high-speed database loading and unloading. This is a flexible and extensible tool which adapts at runtime to the formats of records entered and allows creation and incorporation of new components obtained from any program that permits integration and reuse of external legacy codes and storage engines.

Course Content:

Introduction

Ab initio Architecture

♦ Understanding GDE

♦ Understanding the Co-op System

♦ Understanding the EME/Application hub

Understanding Host connection settings

♦ Configure host settings

Understanding Abinitio Jobs/ Graphs

♦ Basics of Graphs

♦ Building and executing graphs

♦ Understanding Sandboxes/Projects

Understanding components of a graph

♦ Record formats, DML, Transform functions, Key specifiers

♦ Dataset components/ Table components/Program components

♦ Layout

♦ Parameters

♦ Validating the graphs and understanding the error messages

♦ Component Overview-Editors

♦ Record Format Editors

♦ Expression Editors

♦ Transform Editors

♦ Key Specifier Editors

♦ Package Editors

♦ Variable Editors

Component Overview-Dataset components

♦ Input file

♦ Output File

♦ Intermediate file

♦ Lookup files and Lookup Functions

♦ Filter by expression

♦ Dedup sorted

♦ Reformat

♦ Aggregate

♦ Scan

♦ Rollup

♦ Join

♦ Match sorted

♦ Normalize

♦ Denormalize Sorted

Understanding partitioning Concepts and multi files

♦ Understanding Multi files

♦ Understanding Parallelism

♦ Data Parallelism

♦ Component Parallelism

♦ Pipeline parallelism

Component Overview-Partition components

♦ Broadcast

♦ Partition by key

♦ Partition by expression

♦ Partition by round-robin

♦ Partition by range

♦ Partition by the load balance

Component Overview-Departition components

♦ Gather

♦ Concatenate

♦ Interleave

♦ Merge

Component Overview-Database Components, DBC file configuration

♦ Understanding database configuration

♦ Input table

♦ Output table

♦ Run SQL

♦ Truncate Table

♦ Update Table

♦ Join with DB

Component Overview- Miscellaneous Components

♦ Redefine format

♦ Gather Logs

♦ Replicate

♦ Run Program

♦ Trash

Component Overview- Validate Components

♦ Check Order

♦ Compare Records

♦ Validate Records

♦ Generate Record

♦ Create Data

♦ Compute Checksum

Understanding Performance Tuning

♦ Component Folding

Additional Graph concepts

♦ Tagging

♦ Branching

♦ Checkin-Checkout

♦ Locking

♦ Common projects

♦ Dependancy analysis/Impact analysis

♦ Generic Graphs/Reusable Graphs

♦ Conditional components

♦ Concept of Phases and checkpoint

Understanding Plans/ConductITUnderstanding Continuous Flows

Understanding various command-line options/ configuration Variables

♦ M commands

♦ Air commands

♦ Configuration variables

♦ Environment variables

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.