English
  • Data Engineering Integration 10.5.2
  • All Products

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

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
}