Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function Reference

Exporting Data

Exporting Data

You can export the data that appears in the
Data Viewer
view to a JSON file. Export data when you want to create a local copy of the data.
  1. In the
    Data Viewer
    view, right-click the results and select
    Export Data
    .
  2. Enter a file name.
  3. Select the location where you want to save the file.
  4. Click
    OK
    .
The following rules and guidelines apply when you export data to a JSON file:
  • JSON keys must be strings. If the source data is a map that uses structures as keys, the Data Integration Service serializes the keys when you export the data. The exported JSON file might include escape characters before double quotation marks that are added during serialization.
  • JSON does not support binary data. When you export data that includes binary keys, the Data Integration Service replaces the key with the string "<binary>" which results in invalid JSON.
  • If the source data is a map that contains duplicate keys of a complex data type, the Data Integration Service might produce invalid JSON when you export the preview data.


Updated September 28, 2020