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