AbInitio Training

  • Overview
  • Course Content
  • Drop us a Query

AB Initio Training aims to offer enlightenment on how Ab Initio  works with the client-server model. The candidates would get the chance to learn fourth generation data analysis, data manipulation, batch processing graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data.

 Moreover, the AB Initio software has been designed to support a complete range of business applications, from simple to the most complex. The candidates develop and understanding about the terminology and know about the client is called “Graphical Development Environment” (you can call it GDE).It resides on user desktop. The server or back end process is called Co-Operating System”. The Co-Operating System can reside on a mainframe or UNIX remote machine.

After completing this Ab Initio Training, the candidates would be able to:

  • Understand the “Graphical Development Environment” (you can call it GDE)
  • Know server or back end process is called Co-Operating System”
  • What is Abinitio Architecture?
  • Get an overview of .dat and .dml files
Target audience

The course is ideal for data analytics professionals, the one who has basic knowledge of UNIX Shell Scripting, SQL and PL/SQL.

Prerequisites

The candidates should have the knowledge about SQL and PL/SQL and Basic Knowledge on UNIX Shell Scripting prior joining Ab Initio Training.

1. Introduction to Abinitio

2. Abinitio Architecture

3. Graph Programming

4. Introduction to .dat and .dml files

5. Partition Components

  • Braod Cast
  • Partition by Expression
  • partition by range
  • partition by community
  • partition by percentage
  • partition by Round Robin

6. Departition Components

  • Concatenate
  • Gather
  • Interleave
  • Merge

7. Multifile System (MFS)

8. Types of parallelism

9. Layouts

10. Sort Components

  • Sort
  • Sort with in groups
  • Sample
  • Partition by key and sort

11. Transform Components

  • Filter by expression
  • Aggregate
  • Scan
  • Rollup
  • Denormalize Sorted
  • Normalize
  • Reformat
  • Match sorted
  • Dedup sorted

12. Working with Databases

13. Database components

  • Run SQL
  • Input Table
  • Output Table
  • Truncate Table
  • Update table

14. Phase and check Points

15. Miscellaneous component

  • Gather logs
  • Run program
  • Redefine format
  • Trash
  • Replicate

16. Dataset Components

  • Input File
  • Output File
  • Lookup File
  • Intermediate File

17. FTP Components

  • FTP From
  • FTP To

18. Compress Components

  • Compress
  • Uncompress
  • Gzip
  • Gunzip

19. Validate Component

  • Check Order
  • Generate Records
  • Generate Random bytes
  • Compare Records
  • Compute Check Sum
  • Compare Check Sum

20. Translate components

  • Record XML
  • Write XML

21. Project and Sandbox

22. Performance Tuning

A Few Things You'll Love!

What our Students Speak

+