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

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.

0 COMMENTS

We’d like to hear from you!