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

Numeric Value Expressions

Numeric Value Expressions

Arithmetic operators are evaluated within an expression from left to right, in the following order of precedence:
  1. Unary Plus ( + ) and Minus ( - )
  2. Multiplication ( * ) and Division ( / )
  3. Addition ( + ) and Subtraction ( - )
Parentheses may be employed, however, to override the order of evaluation. Expressions within parentheses are evaluated before other parts of the expression. Within a level of precedence, operations are performed in order from left to right. Expressions that use arithmetic operators require numeric operands, and always produce numeric values.

0 COMMENTS

We’d like to hear from you!