Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function 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 September 28, 2020