Advanced Ab Initio Partitioning and Parallelism

Duration: Hours

Enquiry


    Category: Tag:

    Training Mode: Online

    Description

    AB INITIO Training in Bangalore Offered by Locus IT with 100% Hands on Practical Classes with Best Industrial Experts and Working On Real Time Projects.

    Prerequisite:

    • Basic Programming
    • UNIX
    • SQL

    Data Warehousing Basics

    • Technology Life cycle
    • OLTP OLAP Based Systems
    • Data warehouse DataMart
    • ETL Architecture
    • Dimension & Facts
    • Slowly changing Dimensions

    Unix commands required for working on Ab Initio Co Op installed machine –

    • An Introduction
    • Ab Initio Products – An Overview Ab Initio Architecture Parallelism
    • GDE Overview
    • Establishing Connection from GDE to Co Op Data Manipulation Language
    • Different source system & record format types

    Data set Components used for Data Extraction/Loading

    Hands on with the Files/Tables creation required for scenarios to build retail warehouse

    • Input/output File/Table
    • Lookup File
    • Run SQL
    • Truncate Table
    • Update Table

    Transform Functions –

    User Defined Vs Predefined

    Sort Components

    Hands on with mapping documents to build retail warehouse

    • Sort
    • Dedup Sorted
    • Find Splitters

    Transform Components –

    Hands on with mapping documents to build retail warehouse

    • Reformat
    • Filter By Expression
    • Join
    • Fuse

    Transform Components

    Hands on with mapping documents to build retail warehouse

    • Scan
    • Rollup
    • Normalize

    Parameters –

    • An Introduction
    • Types
    • Interpretation
    • Parameter evaluation

    Change Data Capture & Slowly changing dimensions Implementation Phases & Checkpoints

    Debugging

    • Tips & Tricks Performance Tuning
    • Multi-file System

    Partition Components

    Hands on with mapping documents to build retail warehouse

    • Partition By Key/Key & Sort
    • Partition By Expression
    • Partition By Range, Find Splitters
    • Partition By Round Robin

    DE-Partition Components

    Hands on with mapping documents to build retail warehouse

    • Gather
    • Merge
    • Concatenate
    • Interleave
    • Generic graphs
    • Components PSET creation & execution

     Useful Ab Initio commands

    • m_dump
    • m_eval
    • m_wc
    • m_cp, etc

    Introduction to EME –

    • Project Types (Public/Private)
    • Public Projects (stdenv/abenv)
    • Project Overrides
    • Code Check In/Check Out
    • Versioning & Tagging
    • Save Files & Promotion using air commands Rollback & Recovery Mechanism

    Software’s required –

    • Ab Initio GDE
    • Co Op
    • EME – Minimum 10/2.10

    Outcome –

    • Associates can design/develop ETL solutions using products suite as an individual/performer in a
    • Analyze the data quality issues, fix & implement development/enhancements projects
    • Associates can develop framework driven reusable solutions efficiently thereby reducing the turnaround

    Please Visit AB INITIO Official Site: || Locus Academy has more than a decade experience in delivering the training/staffing on AB INITIO  for corporates across the globe. The participants for the training/staffing on AB INITIO  are extremely satisfied and are able to implement the learnings in their on going projects.

    Reviews

    There are no reviews yet.

    Be the first to review “Advanced Ab Initio Partitioning and Parallelism”

    Your email address will not be published. Required fields are marked *

    Enquiry


      Category: Tag: