Ab Initio Development Training With Real Time Scenrios

ETL development realtime training for Ab initio

What you'll learn

Ab Initio real time work

Once trained will be having 3-4 years experience content

NA

Course discussed such a way how to use,what to use, where to use of Ab initio components

Requirements

Unix and Oracle sql basics

Description

Hi There,In the content you will be undergone with Realtime scenario's that i have practically implemented in Realtime, in the course we  have deeply discussed on transformation components still ETL developer responsibility is to mold the data as mentioned in Demo, so mainly concentrated on Transformation components, Along with transform component's discussed on other components like DB, Partition , Departation , Compress, SFTP, Miscellaneous , validate, xml, lookup and types and advanced topics like psets, conduct-it, sub graphs, Interpretation, start script ,end script, phases, check points and rollback and recovery mechanism. The content will be delivered such a way in how many ways we can use that component, simulation with some example, Performance tuning techniques at same time  and interview questions will be discussed at certain that components for deeper understanding of Tool.The content was discussed day to day what are challenges we will be facing and respective solutions too, Total content was divided into 2 parts like basic and advanced.In Basic all component's and its details will be discussed with examples and in advanced topics how to reuse same graph for multiple purpose etc have discussed detailed way. Basic was delivered for around 13-15 hours and advanced with 12+hours. 

Overview

Section 1: Introduction

Lecture 1 Demo

Lecture 2 Content Discussion

Lecture 3 Input and output File comp

Lecture 4 Filter by Expression comp

Lecture 5 Sort comp

Lecture 6 Dedup sort comp

Lecture 7 Dedup and sort within group

Lecture 8 Reformat comp

Lecture 9 String Fuctions

Lecture 10 Rollup-1

Lecture 11 Rollup-2

Lecture 12 Scan,scan with rollup and join-1

Lecture 13 Join-2 and Fuse

Lecture 14 Lookup-1

Lecture 15 Catalogued and dyanamic lookup

Lecture 16 Normalize

Lecture 17 DBC file and IP table comp

Lecture 18 OP table and other DB comp

Lecture 19 Parallelism and MFS

Lecture 20 Partation comp

Lecture 21 Departation comp

Lecture 22 Compress,xml,validation comp

Lecture 23 Miscellenious

Lecture 24 Real time env explination

Lecture 25 Unix and m_commands

Lecture 26 air commands and tag creation

Lecture 27 Debugging,interpretation,scd,cdc,scripts

Lecture 28 Brief on PDL and Interpretation

Lecture 29 Detailed content

Begineers and who dont have IT knowledge