Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.0
  3. Part 2: Version 10.2.2
  4. Part 3: Version 10.2.1
  5. Part 4: Version 10.2
  6. Part 5: Version 10.1.1
  7. Part 6: Version 10.1

Decimal Data Types

Decimal Data Types

If you upgrade to version 10.2.2, mappings that are enabled for high-precision mode and run on the Spark engine must use a scale argument for the TO_DECIMAL and TO_DECIMAL38 functions. If the functions do not have a scale argument, the mappings will fail.
For example, if a pre-upgraded mapping uses high-precision mode and contains the expression
TO_DECIMAL(3)
, you must specify a scale argument before you can run the upgraded mapping on the Spark engine. When the expression has a scale argument, the expression might be
TO_DECIMAL(3,2)
.
For more information, see the
Informatica Big Data Management 10.2.2 User Guide
.

0 COMMENTS

We’d like to hear from you!