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

Flatten Hierarchical Data

Flatten Hierarchical Data

You can flatten elements of hierarchical data into relational data. Use the
Flatten Complex Port
wizard in the Developer tool to perform the conversion.
The wizard converts hierarchical data to relational data. When you have hierarchical data with nested data type, you can select specific elements or all elements of complex data type to flatten.
Based on the data type of the complex port, the wizard performs the following tasks:
struct
  • Adds an Expression transformation with flattened output ports. The expression for the output ports uses the dot operator to extract elements in the struct.
  • Adds a final Expression transformation that contains a dynamic port with all ports from the upstream transformation including the flattened struct ports.
array
Adds a Normalizer transformation with flattened output ports. The wizard flattens the array field in the Normalizer view.
Adds a final Expression transformation that contains a dynamic port with all ports from the upstream transformation including the flattened array ports.
nested data type
Adds one or more Expression and Normalizer transformations with flattened output ports. If you select a child element of a nested complex port, the wizard flattens both the parent and child elements.
Adds a final Expression transformation that contains a dynamic port with all ports from the upstream transformation including the flattened ports.


Updated September 24, 2020