Table of Contents

Search

  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 a Struct Element Using the Dot Operator

Extracting a Struct Element Using the Dot Operator

Use the dot operator in expressions to extract elements of a struct.
  1. In the transformation, create an output port of the same data type as the return value of the struct element that you want to extract.
  2. In the
    Expression
    column for the output port, click the
    Open
    button.
    The Expression Editor opens.
  3. Delete the existing expression in the editor.
  4. Click the
    Ports
    tab and select the struct port.
  5. Enter a dot after the port name.
    The Developer tool displays a list of elements in the struct.
    The Expression Editor shows a list of elements in the struct.
  6. Select the element that you want to extract.
  7. Click
    Validate
    to validate the expression.
  8. Click
    OK
    to exit the Validate Expression dialog box.
  9. Click
    OK
    to exit the Expression Editor.


Updated October 23, 2019