Opportunities in Digital Business
“Progress is impossible without change, and those who cannot change their minds cannot change anything.”
-George Bernard Shaw
The mathematical symbol for change is the Greek uppercase letter delta: Δ. Read More
Creating Change Data Capture Reports in IRI Workbench
There is now a bulk/batch Change Data Capture (CDC) wizard in the IRI Workbench GUI for Voracity, built on Eclipse™. This new graphical report builder compares previous and current data sources based on a flag field you select, and gives you the option of producing five different targets — Cumulative, Delete, Equal, Insert, and Update — or any combination thereof. Read More
Scheduling Jobs in IRI Workbench
In addition to running IRI software from the command line, in batch scripts, DBMS schedulers like Oracle’s, or through third-party workflow automation suites like Stonebranch Universal Controller, the IRI Workbench development environment now has a built-in job scheduler. Read More
DSN Files and IRI Software
A DSN (database source name) file allows multiple users to connect to a database with information in a flat file. It is used by the database client program — in this case, software in the IRI Workbench — to connect to a database. Read More
Scheduling IRI Jobs in Stonebranch Universal Controller
Beyond the client-side task launch scheduler provided in the IRI Workbench graphical IDE for Voracity™ ETL and sub-product users, server-side IRI job scheduling is also possible in simple tools like cron, and more advanced workflow automation suites like StoneBranch Universal Automation Center™ (UAC), CA Autosys, Cisco TES, IBM Tivoli, and ASC ActiveBatch. Read More
ETL Task Testing with the IRI Voracity Preview Feature
During the design of IRI Voracity workflows in the IRI Workbench (Eclipse) GUI, you can preview the results of one or more transforms before saving or running the project. Read More
Flat-File Profiling
Update: Q2’16: In addition to the flat-file profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced robust data classification that enables the application of field rules for multi-source data transformation and protection through data class libraries. Read More
IRI Date & Time Functionality Gets a Boost
IRI software can now perform advanced date/time format conversion and value calculation using the C++ Boost© Date_Time library. It supports input date and/or time data in generic or custom formats, the ability to add or subtract by time unit (i.e., Read More
The Orca and IRI Voracity
Intelligent. Fierce. Powerful. Fast. Voracious.
Killer whales, or orcas thrive in every world ocean and in many seas. They are intelligent, lively, and highly social creatures that form close, matrilineal groups. Read More
The Importance of a Unified View of the Customer
Customers drive business, and they want to be understood and valued. That starts with getting their (only) name right, and having an accurate view of their transaction history, preferences, and related information. Read More
Introduction to Slowly Changing Dimensions (SCD)
A dimension is a structure that categorizes a collection of information so that meaningful answers to questions regarding that information may be obtained. Dimensions in data management and data warehouses contain relatively static data; however, this dimensional data can change slowly over time and at unpredictable intervals. Read More