Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings in the Hadoop Environment
  4. Mapping Sources in the Hadoop Environment
  5. Mapping Targets in the Hadoop Environment
  6. Mapping Transformations in the Hadoop Environment
  7. Processing Hierarchical Data on the Spark Engine
  8. Configuring Transformations to Process Hierarchical Data
  9. Processing Unstructured and Semi-structured Data with an Intelligent Structure Model
  10. Stateful Computing on the Spark Engine
  11. Monitoring Mappings in the Hadoop Environment
  12. Mappings in the Native Environment
  13. Profiles
  14. Native Environment Optimization
  15. Cluster Workflows
  16. Connections
  17. Data Type Reference
  18. Function Reference
  19. Parameter 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 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 for the Spark engine.
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.


Updated October 23, 2019