Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Cluster Workflows
  8. Profiles
  9. Monitoring
  10. Hierarchical Data Processing
  11. Hierarchical Data Processing Configuration
  12. Hierarchical Data Processing with Schema Changes
  13. Intelligent Structure Models
  14. Stateful Computing
  15. Connections
  16. Data Type Reference
  17. Function Reference

User Guide

User Guide

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!