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

Data Viewer

Data Viewer

When you preview data, you view ports in the preview point represented as columns in the Data Viewer.
To identify the hierarchical types, the following punctuation icons are used:
  • [ ] is used to indicate array data type.
  • { } is used to indicate struct data type.
  • <,> is used to indicate map data type.
You can see the following information in the Data Viewer:
  • View tooltips to see details regarding the type of hierarchical data. If you need to limit the number of ports that appear, you can choose the ports you want to view in the output.
  • Highlight a field to see the details in the hierarchical type panel. When you right click any hierarchy field, you can export the data in that field in JSON format.
  • If the data includes dates, note that date fields have an additional time stamp component (00:00:00).
If the Data Integration Service node and the cluster node are located in different time zones, the Data Viewer displays a date and time based on the time zone of the cluster instead of the time zone of the Data Integration Service or Data Viewer.


Updated September 28, 2020