3.75 out of 5
3.75
2 reviews on Udemy

Ab Initio ETL Tool – Beginner to Expert in 10 days

Master the most important components and their run time behaviors. Includes interview & scenario based questions.
Instructor:
ST Solutions
13 students enrolled
The installation process in Ab Initio
Most important and frequently used components in Ab Initio
Multifiles and Partitioning components in depth analysis with examples
EME overview and architecture
M commands and air commands in Ab Initio
Debugging and performance tuning techniques in Ab Initio
Introduction to continuous flows

Ab Initio tool is a fourth generation powerful GUIĀ based parallel processing tool for data analysis, data manipulation and batch-processing used to Extract, Transform and Load (ETL)data. This tool or software works with the client-server model.

The course is divided into three sections and covers all the important topics of Ab Initio. It contains frequently asked interview questions in the end.

GDE version of the tool in the video is 2.15 and 3.0.5

Basics of Ab Initio

1
Introduction & Installation
2
FBE continution and VM and OS installation
3
Reformat
4
Reformat output index(s) and sort components
5
Dedupsorted and Join introduction
6
Join component
7
Lookup Session 1
8
Lookup Session 2

Intermediate Ab Initio

1
Rollup Session 1
2
Rollup Session 2 - Ans Scan and Denormalize
3
Denorm and Normalize
4
FUSE, Multifile System Introduction
5
Partition by Round robin and Range
6
Partitioning continued & Departitioning
7
DBC file
8
DB - Input table output table
9
Update table and truncate table, RUN SQL
10
DB SCD TYPE2 Discussion

Advanced Ab Initio Topics

1
Validate components
2
Read Multiple files
3
Reading and Writing excel data
4
Split xml component
5
EME Overview
6
EME Architecture
7
EME Concepts and Few Air Commands
8
Air Commands and PSETs and Plans Introduction
9
Creating Parameters and Generic Graph
10
Parameters Interpretation
11
Generic graph-PSETS
12
COOP Utilities Session 1
13
M commands continued
14
Start & End Script and Conduct IT Overview
15
Conduct IT and Plans
16
UNIX ENV Discussions
17
Phase and Checkpoint
18
Debugging Techniques in Ab Initio
19
Performance Tuning
20
Continuous Flow Overview and .dbc file Setup
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.8
3.8 out of 5
2 Ratings

Detailed Rating

Stars 5
0
Stars 4
1
Stars 3
1
Stars 2
0
Stars 1
0
ab93609e78990a606e1878a5d41ba369
30-Day Money-Back Guarantee

Includes

37 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion