Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in the Hadoop Environment
  5. Mapping Objects in the Hadoop Environment
  6. Processing Hierarchical Data on the Spark Engine
  7. Stateful Computing on the Spark Engine
  8. Monitoring Mappings in the Hadoop Environment
  9. Mappings in the Native Environment
  10. Profiles
  11. Native Environment Optimization
  12. Data Type Reference
  13. Complex File Data Object Properties
  14. Function Reference
  15. Parameter Reference

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
    .


Updated December 13, 2018