CoSort Certification

 

Next Steps
Overview Voracity CoSort FACT NextForm FieldShield CellShield EE DarkShield RowGen

When you have attained a level of expertise in the use of IRI CoSort -- through either on-the-job experience or an authorized training course -- you have likely qualified for an official certification letter suitable for consulting engagements, job applications, and IT training centers. Following are various levels of certification you can obtain from IRI, and the USD cost of each certificate (which does not include training or validation).

Installation

SortCL I

SortCL II

SortCL III

SortCL IV

Software Installation, Configuration, and Tuning

Prerequisites

  • None

Requirements

Demonstrate proficiency in CLI and GUI loading, CLI software licensing, environment variable setting, and the importation and execution of CLI job samples and GUI demo projects in the IRI Workbench. Establish and test data flows and DTP views over ODBC and JDCB connections to Oracle or another relational database. Modify and explain the performance of CoSort and other jobs through both Unix cosortrc parameters and Windows registry settings. Be familiar with all package contents and metadata utilities.

Cost

$75 USD

CoSort SortCL I

Prerequisites

  • None

Requirements

Demonstrate proficiency in data definition and job specification syntax, design, and execution from the command line, IRI Workbench and batch. Source disparate inputs and remap fields to multiple targets with basic filter, sort, join, and summary options. Familiarity with metadata and JCL sort parm conversion. Explain the use of CoSort in data warehouse integration and staging, and in legacy sort migrations.

Cost

$75 USD

CoSort SortCL II

Prerequisites

  • CoSort SortCL I

Requirements

Data type, file format, and endian conversion; bespoke reports with cross-calculation and expression logic; apply complex aggregations (break groups, ranking, running, lead and lag functions). Use altseq, else-if conditions, conditional fields and data statements, conversion specifiers, hex values, locale, and Unicode. Explain the uses of CoSort as a standalone business intelligence tool, and as an accelerator for other BI tools.

Cost

$100 USD

CoSort SortCL III

Prerequisites

  • CoSort SortCL II

Requirements

Change data capture, pivoting, slowly changing dimensions, bulk load targeting in the IRI Workbench for DB migrations, reorgs, and test data population. Schedule jobs with dependencies using Oracle DBMS_SCHEDULER or another method. Team share and manage job versions, metadata, master data, and lineage information in IRI Workbench. Compare and contrast CoSort with other ETL, ELT, ETLT, and ODS platforms and methods.

Cost

$100 USD

CoSort SortCL IV

Prerequisites

  • CoSort SortCL IV

Requirements

C programs for custom (field-level) transforms, /INPROC and/or /OUTPROC operations, and sortcl_routine(api) calls. Articulate real-world applications of each.

Cost

$100 USD

Share this page

Request More Information

Live Chat

* indicates a required field.
IRI does NOT share your information.