English
  • Data Engineering Integration 10.2.2
  • All Products

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

User Guide

User Guide

Back Next

Example - Dynamic Expression to Construct a Dynamic Struct

Example - Dynamic Expression to Construct a Dynamic Struct

An Expression transformation has a dynamic port from which you want to construct a struct.
An Expression transformation has the following generated input ports: 
Name		String
Street	String
City		String
State		String
Zip		Integer
The transformation contains a dynamic complex output port called d_structAddress. You want to construct a struct and return the result to d_structAddress.
You create a port selector AddressPS and define the selection rules to include the following ports by name: 
Street	String
City		String
State		String
Zip		Integer
Then, you create a dynamic expression with the STRUCT function.
The following image shows a dynamic expression that references a port selector AddressPS:
In the
Output Port Settings
 area, specify the port selector AddressPS as the base port.
The dynamic expression creates the following struct with the elements from the port selector: 
d_structAddress{
  Street	String
  City		String
  State		String
  Zip		Integer
}