Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

JSON Data Types and Transformation Data Types

JSON Data Types and Transformation Data Types

JSON data types map to transformation data types that the Data Integration Service uses to move data across platforms.
The following table compares the JSON data types that the Data Integration Service supports and the corresponding transformation data types:
JSON
Transformation
Range
Array
Array
Unlimited number of characters.
Double
Double
Precision of 15 digits.
Integer
Integer
-2,147,483,648 to 2,147,483,647.
Precision of 10, scale of 0.
Object
Struct
Unlimited number of characters.
String
String
1 to 104,857,600 characters.
You can use JSON data types to read and write complex file objects in mappings that run on the Spark engine only.

Unsupported JSON Data Types

The Developer tool does not support the following JSON data types:
  • Date
  • Decimal
  • Timestamp
  • Enum
  • Union

0 COMMENTS

We’d like to hear from you!