Performing Summary Aggregation in CoSort (IRI Workbench) [video]
This demonstration shows how to use the IRI Workbench to create an aggregation job using sums. Workbench is used to create the job script in the SortCL language. Read More
Quick Stats Function in IRI Voracity [video]
This demonstration shows how to use the Quick Stats Function in IRI Workbench and our data management platform, Voracity. The Quick Stats Function can be used in any IRI job script to auto-generate a linear regression analysis report in pdf format. Read More
Sort Demonstration [video]
This demonstration shows how to set up a sort job for CoSort using the IRI Workbench. The sort is accomplished using the SortCL language. This video takes a CSV input file, shows how to define the sort keys and options, and demonstrates how to define the targets for output. Read More
Scheduling and Running an IRI Voracity ETL Workflow [video]
This demonstration shows how to execute an existing workflow in IRI Voracity using the built-in job scheduler in its Eclipse GUI, IRI Workbench. The scheduler launches any jobs you’ve queued in the run configuration dialog one or more times. Read More
Performing a Left Outer Join Where All Matched Records…
This demonstration shows how to create a left outer join where the match is based on one field and we use the ONLY parameter to discard matches. Read More
Introduction to IRI RowGen Test Data [video]
IRI RowGen automatically builds and populates massive database, file, and report targets with structurally and referentially correct test data that’s also fully customizable. Enjoy the same simple 4GL or free Eclipse GUI to: stress-test ETL environments, outsource development, and benchmark new systems. Read More
Performing an Inner Join with the IRI Workbench Demonstration…
This demonstration shows how to create an inner join job for CoSort using the IRI Workbench. The join is accomplished using the SortCL tool in CoSort and the Workbench creates the job script using the SortCL language. Read More
Creating a Metadata File Using a Data File with…
This demonstration shows how to create a metadata file for a data file with fixed field lengths. Metadata files contain the definitions of data sources or targets such as flat files, database tables and pipes. Read More
Introduction to IRI FieldShield Data Masking [video]
IRI FieldShield is the fastest, easiest, and most robust data masking solution available for databases and structured (and some semi-structured) files. DBAs, data security, data governance, and compliance teams use FieldShield to find, classify, and protect personally identifiable information (PII) and other sensitive data using static or dynamic data masking functions. Read More
Building an ETL Workflow: Intro to IRI Voracity Diagrams…
This demonstration shows how to use IRI Voracity in Workbench to create an ETL workflow from scratch.
Flow diagrams are an all encompassing job design tool meant to allow the user the ability to integrate, migrate, govern, and analyze data in multiple formats. Read More