Ab Initio Software is an American multinational enterprise software corporation based in Lexington, Massachusetts. The company specializes in high-volume data processing applications and enterprise application integration.
The Ab Initio products are provided on a user-friendly homogeneous and heterogeneous platform for parallel data processing applications. These applications perform functions relating to fourth generation data analysis, batch processing, complex events, quantitative and qualitative data processing, data manipulation graphical user interface (GUI)-based parallel processing software which is commonly used to extract, transform, and load (ETL) data.
It is a flexible and extensible tool which adapts at runtime to the formats of records entered. It allows creation and incorporation of new components obtained from any program that permits integration and reuse of external legacy codes and storage engines.
Ab Initio is a Business Intelligence platform comprised of 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 GUI-based parallel processing tool for ETL data management and analysis.
Anyone who is working on Maintenance project where the underlying ETL tool is Ab Initio. Anyone who wanted to better their ETL skill sets by learning the happening tool in the Market. Knowledge in the database and/or data warehouse.
Knowledge about different components and its purpose. Build a graph adhering the business requirement. How to blend different tools for different requirement. Complete understanding of Data Warehousing and ETL terminologies.
You will be hired as data analyst, ETL developer in the companies like wells Fargo, Bank of America, DBS, commonwealth bank and more.
The main topics covered Introduction to Ab initio software, Understanding Host connection settings, Understanding components of a graph, Component Overview-Dataset components, Component Overview-Dataset components, Lookup files and Lookup Functions, Component Overview- Validate Components, performance tuning and more.
Introduction to Ab initio software
Ab initio Architecture
Understanding Co-op System
Understanding EME/Application hub
Understanding Host connection settings
Configure host settings
Understanding Abinitio Jobs/ Graphs
Basics of Graphs
Building and executing graphs
Understanding components of a graph
Record formats, DML, Transform functions, Key specifiers
Dataset components/ Table components/Program components
Validating the graphs and understanding the error messages
Record Format Editors
Key Specifier Editors
Component Overview-Dataset components
Lookup files and Lookup Functions
Filter by expression
Understanding partitioning Concepts and multi files
Understanding Multi files
Component Overview-Partition components
Partition by key
Partition by expression
Partition by round robin
Partition by range
Partition by load balance
Component Overview-DE partition components
Component Overview-Database Components, DBC file configuration
Understanding database configuration
Join with DB
Component Overview- Miscellaneous Components
Component Overview- Validate Components
Understanding Performance Tuning
Additional Graph concepts
Dependency analysis/Impact analysis
Generic Graphs/Reusable Graphs
Concept of Phases and check point
Understanding Plans/Conduct IT Understanding Continuous Flows
Understanding various command line options/ configuration Variables