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

Array Data Type

Array Data Type

An array data type represents an ordered collection of elements. To pass, generate, or process array data, assign array data type to ports.
An array is a zero-based indexed list. An array index indicates the position of the array element. For example, the array index 0 indicates the first element in an array. The transformation language includes operators to access array elements and functions to generate and process array data.
An array can be one-dimensional or multidimensional. A one-dimensional array is a linear array. A multidimensional array is an array of arrays. Array transformation data types can have up to five dimensions.

Format

array <data_type> []
The following table describes the arguments for this data type:
Argument
Description
array
Name of the array column or port.
data_type
Data type of the elements in an array.
The elements can be primitive data types or complex data types. All elements in the array must be of the same data type.
[]
Dimension of the array represented as subscript.
A single subscript
[]
represents a one-dimensional array. Two subscripts
[][]
represent a two-dimensional array.
Elements in each dimension are of the same data type.
The elements of an array do not have names. The number of elements in an array can be different for each row.

Array Examples

One-dimensional array
The following array column represents a one-dimensional array of string elements that contains customer phone numbers:
custphone string[]
The following example shows data values for the custphone column:
custphone
[205-128-6478,722-515-2889]
[107-081-0961,718-051-8116]
[107-031-0961,NULL]
Two-dimensional array
The following array column represents a two-dimensional array of string elements that contains customer work and personal email addresses.
email_work_pers string[][]
The following example shows data values for the email_work_pers column:
email_work_pers
[john_baer@xyz.com,jbaer@xyz.com][john.baer@fgh.com,jbaer@ijk.com]
[bobbi_apperley@xyz.com,bapperl@xyz.com][apperlbob@fgh.com,bobbi@ijk.com]
[linda_bender@xyz.com,lbender@xyz.com][l.bender@fgh.com,NULL]

0 COMMENTS

We’d like to hear from you!