Table of Contents


  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings in the Hadoop Environment
  4. Mapping Sources in the Hadoop Environment
  5. Mapping Targets in the Hadoop Environment
  6. Mapping Transformations in the Hadoop Environment
  7. Processing Hierarchical Data on the Spark Engine
  8. Configuring Transformations to Process Hierarchical Data
  9. Processing Unstructured and Semi-structured Data with an Intelligent Structure Model
  10. Stateful Computing on the Spark Engine
  11. Monitoring Mappings in the Hadoop Environment
  12. Mappings in the Native Environment
  13. Profiles
  14. Native Environment Optimization
  15. Cluster Workflows
  16. Connections
  17. Data Type Reference
  18. Function Reference
  19. Parameter Reference

Extracting Elements from a Complex Port

Extracting Elements from a Complex Port

Use the
Extract from Complex Port
wizard to extract elements from hierarchical data.
  1. In the transformation, select a complex port from which you want to extract elements.
  2. Right-click the selected ports, and select
    Hierarchical Conversions
    Extract from Complex Port
    Extract from Complex Port
    wizard appears with the list of elements in the complex port.
    The wizard displays the elements in the complex port. It contains the Name, Type, Type Configuration, Select Elements, and Array Index columns.
  3. In the
    Select Elements
    column, select the check box for each element that you want to extract.
  4. To extract an array element, specify an array index in the
    Array Index
    If you delete the array index, the wizard extracts the entire array. To extract an element in the struct from a complex port for an array of structs, you must specify an array index value.
    The wizard shows the array index value as 0 when you select an array element.
  5. Click
You can see the following changes in the mapping:
  • The mapping contains a new Expression transformation
    with the following ports:
    • The complex port from which you want to extract elements as the input port.
    • One or more output ports for the extracted elements. The number of elements that you selected to extract determines the number of output ports in the transformation.
    • A dynamic port with ports from the upstream transformation.
    The Expression transformation contains the complex port from which you want to extract elements, the new output ports, and a dynamic port.
  • The output ports contain expressions that use complex operators to extract elements.
    The following image shows the expressions for the output ports in the Expression column on the Ports tab:
    The Ports tab of the Expression transformation shows example expressions that the wizard adds for the new output ports.

Updated October 23, 2019