• Technology Consulting

• Staff Augmentation

• Data Warehousing

Ab Initio

DCKAP has performed Ab Initio Implementations for Fortune 500 clients. Our Consultants perform onsite visits, do a thorough Analysis, provide recommendations and perform end-end implementations. Our Consultants have performed ETL Ab-Initio and Unix/Database custom scripts for design and development of full lifecycle terabyte class size Data Warehouse & BI solutions. We have utilized Ab-Initio suite for design/building of scalable architectures addressing parallelism, data integration, ETL, data repositories and analytics, developed heavily parallel CPU bound ETL process jobs in a dynamic, high-volume environment. Our teams have designed and deployed well-tuned Ab-Initio graph (Generic and Custom) for ODS and DSS instance both windows and UNIX environments. Performed data migration programs between database like Teradata, Oracle, SQL Server and DB2, and PC file formats and added enhancements to existing applications according to regulatory requirements.

Our Ab Initio services include and not limited to:

• Implementation of extract, transformation and load processes using Ab Initio as an ETL tool
• Creating the (MFS) Multi-file, which gives the user the ability to centrally control the distributed data files and they provide the scalability and the kinds of access patterns that parallel applications require
• Developed complex transformations according to various business requirements, to produce new fields on the output
• Developed Complex Ab Initio graphs using various components such as Reformat, Join, Roll-up, and Filter by Expression, Sort to facilitate cataloging flat files into EDS Data Hub. The components used depends upon the various business requirements
• Performed data cleansing and data validation, while creating Ab Initio graphs by using inquiry and error functions like is_valid, is_defined, is_error ,is_null , various string functions like string_trim, string_concat, string_substring etc and various decimal functions like decimal_strip,decimal_lpad, etc
• Deployed Ab Initio graphs and ran them through Ad Hoc server for adhoc jobs
• Designed and deployed well-tuned Ab-Initio graph (Generic and Custom) for ODS and DSS instance both windows and UNIX environments.
• Developed ETL mappings from source systems to target database using Ab Initio.
• Ab Initio Data Profiler for examining the data available in an existing database and collecting statistics and information about that data.
• And more

Click here to request for a quote or call us at 1-510-796-2525 for free Ab Initio Consultation.