Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Include or Exclude Ports

Include or Exclude Ports

You can include or exclude ports based on the port name or data type. Each input rule uses an operator and selection criteria to filter ports. You can define multiple rules. The Data Integration Service applies rules in the order in which they appear in the input rules list. Include all ports is the default input rule.
Configure the following input rule settings to determine which ports to include or exclude:
Operator
Determines whether to include or exclude ports. Default setting is to include ports.
Selection Criteria
Determines whether to filter ports based on port names or data types. When you choose the selection criteria, an input rule detail dialog box appears based on the criteria. For example, you provide the
Name
selection criteria details in the
Input Rule Detail By Name List
dialog box
Detail
Determines which ports to filter based on the details that you provide for port names or data type.
The following table describes the selection criteria and how to specify the details for the criteria:
Selection Criteria
Description
Criteria Details
All
Includes all ports. Do not use this selection criteria with exclude operator.
You do not have to specify any details.
Name
Filters ports based on the port name.
Select the port names from a list of values or use a parameter of type Port or Port List. You can also select the port names by source name.
Name values are not case sensitive.
Type
Filters ports based on the data type of the port.
Select data types from a list.
Pattern
Filters ports based on the pattern of the port name.
Choose prefix, suffix, or regular expression as the pattern type for the port name. Then, enter a value for the pattern or use a parameter of type String. You can also select the ports by source name to find the pattern in the source name.
Pattern values are not case sensitive.
Complex Data Type Definition
Filters ports based on the complex data type definition.
Choose prefix, suffix, or regular expression as the pattern type for the complex data type definition. Then, enter a value for the pattern or use a parameter of type String.
Pattern values are not case sensitive.

0 COMMENTS

We’d like to hear from you!