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

Complex Data Types

Complex Data Types

A complex data type is a transformation data type that represents multiple data values in a single column position. The data values are called elements. Elements in a complex data type can be of primitive or complex data types. Use complex data types to process hierarchical data in mappings that run on the Spark or Databricks Spark engine.
Transformation data types include the following data types:
Primitive data type
A transformation data type that represents a single data value in a single column position. Data types such as decimal, integer, and string are primitive data types. You can assign primitive data types to ports in any transformation.
Complex data type
A transformation data type that represents multiple data values in a single column position. Data types such as array, map, and struct are complex data types. You can assign complex data types to ports in some transformations.
Nested data type
A complex data type that contains elements of complex data types. Complex data types such as an array of structs or a struct with an array of other structs are nested data types.
The following table lists the complex data types:
Complex Data Type
Description
array
An array is an ordered collection of elements.
The elements can be of a primitive or complex data type. All elements in the array must be of the same data type.
map
A map is an unordered collection of key-value pair elements.
The key must be of a primitive data type. The value can be of a primitive or complex data type.
struct
A struct is a collection of elements of different data types.
The elements can be of primitive or complex data types. Struct has a schema that defines the structure of the data.
The following image shows primitive, complex, and nested data types assigned to ports in a transformation:
The Ports tab in the Properties view of a transformation contains ports of primitive, complex, and nested data types.
  1. Primitive data types
  2. Complex data types
  3. Nested data type
The ports emp_name and emp_sal are of primitive data types. The ports emp_phone, emp_id_dept, and emp_address are of complex data types. The port emp_bonus is of a nested data type. The array contains elements of type struct.

0 COMMENTS

We’d like to hear from you!