Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Oracle and Transformation Datatypes

Oracle and Transformation Datatypes

The following table compares Oracle datatypes and transformation datatypes:
Oracle
Range
Transformation
Range
Blob
Up to 4 GB
Binary
1 to 104,857,600 bytes
Char(L)
1 to 2,000 bytes
String
1 to 104,857,600 characters
Clob
Up to 4 GB
Text
1 to 104,857,600 characters
Date
Jan. 1, 4712 B.C. to Dec. 31, 4712 A.D.
Precision 19, scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Long
Up to 2 GB
Text
1 to 104,857,600 characters
If you include Long data in a mapping, the Integration Service converts it to the transformation String datatype, and truncates it to 104,857,600 characters.
Long Raw
Up to 2 GB
Binary
1 to 104,857,600 bytes
Nchar
1 to 2,000 bytes
Nstring
1 to 104,857,600 characters
Nclob
Up to 4 GB
Ntext
1 to 104,857,600 characters
Number
Precision of 1 to 38
Double
Precision of 15
Number(P,S)
Precision of 1 to 38,
scale of 0 to 38
Decimal
Precision of 1 to 28, scale of 0 to 28
Nvarchar2
1 to 4,000 bytes
Nstring
1 to 104,857,600 characters
Raw(L)
1 to 2,000 bytes
Binary
1 to 104,857,600 bytes
Timestamp
Jan. 1, 4712 B.C. to Dec. 31, 9999 A.D.
Precision 19 to 29, scale 0 to 9
(precision to the nanosecond)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Varchar(L)
1 to 4,000 bytes
String
1 to 104,857,600 characters
Varchar2(L)
1 to 4,000 bytes
String
1 to 104,857,600 characters
XMLType based CLOB storage
Up to 4 GB
Text
1 to 104,857,600 characters


Updated June 25, 2018