OWB - Constant Operator

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

The Constant operator enables you to define constant values in any:

  • PL/SQL
  • or ABAP mapping.
  • but for SQL*Loader mappings, to introduce constants or sequences, use a data generator operator instead.

3 - Properties of a field

  • Expression. Full in the value of the constant.
  • Is predefined constant. If this check box is checked, the constant is inserted direct in the SQL statement and not handle by a function.

It's really useful with sysdate, strings, numbers and fixed dates. It's for performance improvement in large row counts.

sysdate nasty side effects : sysdate comes from a plsql constant it will have the same sysdate for all rows, whereas you use it directly in the insert statement but it can differ, especially when inserting loads of rows

Advertising

4 - Documentation / Reference