Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Connections
  17. Data Type Reference
  18. 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 January 20, 2020