Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Data Quality: Rules To Check For Null In Columns

Free download

Posted by: Informatica Data Quality Unit

Download Data Quality rules that help you to check whether the column consists data or the column contains Null. It also contains a mapping to demonstrate to check for Null in the column using the rules.


Informatica provides the Core accelerator with the Content installer. The Core accelerator contains data quality rules that you can use with data from multiple regions. Core Accelerators provide solutions to common data quality issues in a country, region, or industry. Core Accelerators contain rules, reference tables, demonstration mappings, and demonstration data objects.


Checking for Nulls in the source column/field using rules is part of the Data Quality core accelerators available with the Informatica Data Quality Product. In this example we are checking the source column/fields; if the column/field consists of data the rule will return “Complete” and “Incomplete” if the Column is Null. To achieve this we are making use of following rules comes with the installation of Core Accelerators.


rule_CompletenessChecks for NULL values.
rule_Completeness_Multi_PortChecks multiple ports for NULL values.


  • Informatica Data Quality 9.5.1
Comments Comments (3)