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

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 November 09, 2018