Enquiry Now !      

AB Initio Training Pune, AB Initio institutes Pune, AB Initio Classes and Placement pune

    DURATION OF TRAINING : 6 WEEKENDS

    Syllabus

    Week-1

    Introduction to Abinitio, comparison of Abinitio with other ETL Tools.
    Introduction to a Datawarehouse
    Datawarehouse Architecture
    Types of DatawareHouse Approaches
    Facts & Dimensions
    Modelling concepts Introduction
    Types of schemas
    Abinitio concepts
    Abinitio Architecture
    Relationship Between GDE, Co>op, EME
    Introduction to Sandbox

    Week-2

    Creating a Sandbox
    Relationship between Sandbox and EME
    Air commands
    Check-in, check-out & locking
    Introduction to Graph Programming
    Components Introduction
    Types of Various Components
    Partition components
    Partition components
    Departition Components like: Gather, concatenate, Merge & Interleave
    Assignment 1

    Week-3

    Validate components
    a.Checkorder
    b.compare records
    c.Checksum
    d.Computechecksum
    e.Validate records
    Translate components
    a.Read XML & Write XML
    b.Read EXCEL & Write Excel

    FTP Components
    Compress Components
    Sort Components
    Transform Components:
    a. Dedup- Sort
    b. Filter By Expression components and its internal parameters functions
    Reformat component and its Parameters

    Week-4

    String Functions
    Executing all the string functions by using various transform components
    Transform components
    a.Aggregate components and its parameters
    b.Rollup Components and its parameters
    c.Various Aggregation functions in rollup components
    d. Scan component and its parameters
    Join components and its parameters
    Fuse Component and its internal parameters
    Normalize Component
    Assignment 2

    Week-5

    De-Normalize Sorted Component
    Match Sorted Components
    Miscellaneous Components
    Introduction to Database Components
    Creating .dbc file
    Different types of Orainterfaces in Database components

    Week-6

    Continuous Components
    New Components introduced in the latest version of Abinitio V3.0.5
    Hands on Project
    Interview related questions discussion
    Mock interview session
abinitio
AB Initio


Enquiry Now !