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

Inline Lookup Example

Inline Lookup Example

SELECT c1, c2, c3 FROM S1.T1 WHERE Lookup ( c1 <= %1 AND c2 = %2 AND c3 >= %3, ( '20071222072132021540241263', 158.97, '20071223091422020670233655'), ( '20071218163352021130070420', 12.26 , '20071218163352021130070420'), ( '20071217125938020250714927', 22.20 , '20071217125938020250714927'), ( '20071222085214020220173289', 148.91, '20071222085214020220173289'), ( '20071217121333021600203214', 56.48 , '20071223091422020670233670') ) ;

0 COMMENTS

We’d like to hear from you!