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

Rules and Guidelines for Complex Ports

Rules and Guidelines for Complex Ports

Consider the following rules and guidelines when you work with complex ports:
  • Aggregator transformation. You cannot define a group by value as a complex port.
  • Filter transformation. You cannot use the operators >, < , >=, and <= in a filter condition to compare data in complex ports.
  • Joiner transformation. You cannot use the operators >, < , >=, and <= in a join condition to compare data in complex ports.
  • Lookup transformation. You cannot use a complex port in a lookup condition.
  • Rank transformation. You cannot define a group by or rank value as a complex port.
  • Router transformation. You cannot use the operators >, < , >=, and <= in a group filter condition to compare data in complex ports.
  • Sorter transformation. You cannot define a sort key value as a complex port.
  • You can use complex operators to specify an element of a complex port that is of a primitive data type.
    For example, an array port "emp_names" contains string elements. You can define a group by value as emp_names[0], which is of type string.


Updated September 28, 2020