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

Big Data Management User Guide

Big Data Management User Guide

Extracting an Array Element Using a Subscript Operator

Extracting an Array Element Using a Subscript Operator

Use the subscript operator in expressions to extract one or more elements of an array.
  1. In the transformation, create an output port of the same data type as the return value of the array element that you want to extract.
    To extract more than one element in an array, create an array output port. The data type of the elements in the type configuration for the array port must match the data type of the return value of the array elements.
  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 an array port.
  5. Enter one or more index values within the subscript operator.
    To extract array elements in a multidimensional array, enter index values within each subscript operator.
  6. Click
    Validate
    to validate the expression.
  7. Click
    OK
    to exit the
    Validate Expression
    dialog box.
  8. Click
    OK
    to exit the
    Expression Editor
    .

0 COMMENTS

We’d like to hear from you!