Table of Contents

Search

  1. About the Data Vault SQL Reference
  2. Introduction to SQL Reference for Informatica Data Vault
  3. Date and Time Arithmetic
  4. WHERE Clauses
  5. UNION Operator
  6. Parameterized Query
  7. Functions

Data Vault SQL Reference

Data Vault SQL Reference

NULL Predicates

NULL Predicates

The IS [NOT] NULL operator can be used in WHERE clause predicates to match or exclude null values occurring in a specified data column. Its syntax is as follows (where
x
is typically a column name):

0 COMMENTS

We’d like to hear from you!