About Abinitio

The AbInitio software is a Business Intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, and Enterprise Meta>Environment, Data Profiler and Conduct>It. It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis.

About Instructor

AbInitio Online Training is provided by a real time consultant. The experience acquired by our trainer on AbInitio, is promisingly helpful to the corporate trainee’s. Our instructors are experts in the implementation and support projects.  ASTS always works on real time scenarios. It is extremely useful for the professionals to handle the projects easily in the IT industry.

Prerequisites

• Graduates/Post Graduates are eligible.
• Everyone must have knowledge on SQL and PL/SQL.
• Basic Knowledge on UNIX Shell Scripting.

Terms And Conditions

• We will Provide Supporting to resolve Student practical Issues.
• We will provide server Access and 100% Lab Facility.
• Resume Preparation.
• Interview Questions & Answers.
• We will conduct mock interviews. Student also gets 100% supporting before and after getting job.

Course Content

Introduction to Ab initio
Ab Initio Architecture
Graph Programming
Introduction To .Dat and .Dml Files
Partition Components

• Broad Cast
• Partition by Expression
• Ab Initio Basic Concepts
• partition by range
• partition by community
• partition by percentage
• partition by Round Robin

Departition Components

• Concatenate
• Gather
• Interleave
• Merge

Multifile System (MFS)
Types Of Parallalism
Layouts
Sort Components

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

Transform Components

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

Working With Databases

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

Basics of unix and database

• Creating sandbox.
• Objects in sandbox.
• Check in and checkout of objects in sandbox.
• Start script and End script.
• Objects in graph.
• Introduction to Data Warehousing Concepts

Phase And Check Points

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

Dataset Components

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

FTP Components

• FTP From
• FTP To

Compress Components

• Compress
• Uncompress
• Gzip
• Gunzip

Validate Component

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

Translate Component

• Record XML
• Write XML

Project And Sandbox
Performance Tuning