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

Creating a Struct Port

Creating a Struct Port

Use the
Create Struct Port
wizard to convert data that passes through one or more ports to struct data.
  1. In the transformation, select one or more ports that you want to convert as elements of the struct data.
    The ports you select also determine the elements of the complex data type definition.
    The ports city, state, and zip are selected in the Read transformation.
  2. Right-click the selected ports, and select
    Hierarchical Conversions
    Create Struct Port
    .
    The
    Create Struct Port
    wizard appears with the list of ports that you selected.
    The Create Struct Port wizard contains the Name and Elements text box. It lists the ports that you selected.
  3. Optionally, in the
    Name
    box, change the name of the complex data type definition.
    For example, typedef_address.
  4. Optionally, click
    Choose
    to select other ports in the transformation.
  5. Click
    Finish
    .
You can see the following changes in the mapping:
  • The mapping contains a new Expression transformation
    Create_Struct
    with a struct output port and a dynamic port with ports from the upstream transformation.
    The Create_Struct transformation contains a struct output port and a dynamic port with ports from the upstream transformation.
  • The type definition library contains the new complex data type definition.
    The complex data type definition contains three elements city of type string, state of type string, and zip of type integer.
  • The struct output port references the complex data type definition.
  • The struct output port contains an expression with the STRUCT_AS function. For example,
    STRUCT_AS(:Type.Type_Definition_Library.typedef_address,city,state,zip)


Updated October 23, 2019