The Social Security Number (SSN) in the United States is similar to many other forms of national identification around the world, such that it is a number or set of characters that is designated to a citizen or person who has entered the country for an extended stay on a visa. Read More
Fiscal Codes in Italy are used in much the same way Social Security numbers are used in the United States. The “Codice Fiscale” identifies citizens, taxpayers, or any other person who has entered the country for an extended stay on a visa. Read More
Database Test Data Usage – This blog caught my eye because of its title, Do the right thing when testing with production data. It struck me as oxymoronic, since we know production data should not be used for testing at all …
Of course we know how tempting it is to use production data for testing applications, simulating databases, prototyping ETL operations, and just about anything else that needs to work with the real thing. Read More
Star schema is the simplest and most common database modelling structure used in traditional data warehouse paradigms. The schema resembles a constellation of stars — generally several bright stars (facts) surrounded by dimmer ones (dimensions) where one or more fact tables reference different dimension tables. Read More
It is a common mistake to refer to data masking and data encryption interchangeably to mean the same things. While field-level encryption is considered one of many possible “data masking” functions, we define data masking and encryption as technically distinct processes below. Read More
This demonstration shows how IRI Workbench users can preview the format of data when they are creating job scripts. The data can populate from the actual input sources or from generated test data. Read More
IRI Voracity is an affordable data management platform that streamlines information architectures and helps enterprises leverage the intrinsic value of data without the cost or complexity of multiple tools. Read More
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
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
