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
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
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