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
Format Preserving Encryption (FPE) and Pseudonymization Demonstration [video]
This video is a demonstration of using IRI Workbench to apply format preserving encryption (FPE) and pseudonymization to select fields in a data file to protect personally identifiable information (PII) and protected health information (PHI). 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
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
Big Data Preparation for Analytics – 2015 DBTA Webinar…
BI and analytic tools cannot handle the volume, variety, velocity, and veracity challenges of big data. Today there are many ways to prepare (franchise) that data into the subsets that visualization platforms can ingest, but each typically involves trade-offs between performance, price, and capability. 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
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