Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Appendix A: Connections
  17. Appendix B: Data Type Reference
  18. 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)

0 COMMENTS

We’d like to hear from you!