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

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 }

0 COMMENTS

We’d like to hear from you!