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

Complex Ports

Complex Ports

A complex port is a port that is assigned a complex data type. Based on the complex data type, you must specify the complex port properties. Use complex ports in transformations to pass or process hierarchical data in a mapping.
The following image shows the complex ports and complex port properties on the Ports tab for a transformation:
The Ports tab for a transformation contains complex ports of type array, map, and struct. The transformation also contains a port of nested data type. The Type Configuration Column shows the complex port properties for the complex port elements.
  1. Port
  2. Complex port
  3. Type configuration
  4. Type configuration for an array port
  5. Type configuration for a map port
  6. Type configuration for a struct port
  7. Type configuration for a port of nested data type
Based on the data type, a transformation can include the following ports and port properties:
Port
A port of a primitive data type that you can create in any transformation.
Complex port
A port of a complex or nested data type that you can create in some transformations. Array, map, and struct ports are complex ports. Based on the complex data type, you specify the complex port properties in the type configuration column.
Type configuration
A set of properties that you specify for the complex port. The type configuration determines the data type of the complex data type elements or the schema of the data. You specify the data type of the elements for array and map ports. You specify a complex data type definition for the struct port.
Type configuration for an array port
Properties that determine the data type of the array elements. In the image, the array port emp_phone is a one-dimensional array with an ordered collection of string elements. An array with string elements is also called an array of strings.
Type configuration for a map port
Properties that determine the data type of the key-value pair of the map elements. In the image, the map port emp_id_dept is an unordered collection of key-value pairs of type integer and string.
Type configuration for a struct port
Properties that determine the schema of the data. To represent the schema, you create or import a complex data type definition. In the image, the struct port emp_address references a complex data type definition typedef_adrs.
Type configuration for a port of nested data type
Properties that determine the nested data type. In the image, the array port emp_bonus is a one-dimensional array with an ordered collection of struct elements. The struct elements reference a complex data type definition typedef_bonus. An array with struct elements is also called an array of structs.

0 COMMENTS

We’d like to hear from you!