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

Selection Rules

Selection Rules

The selection rules associated with a port selector determine the ports to include in the port selector.
When you create the selection rules, the
Port Preview
panel shows the ports that qualify from the current input ports. These ports might change. Configure the selection rules to accommodate ports from different sources.
Create selection rules based on the following criteria:
Operator
Includes or excludes the ports that selection rules return. Default is include. You must include ports before you can exclude ports.
Selection Criteria
The type of selection rule you want to create. You can create a rule based on the column name, port type, pattern, or complex data type definition. To include ports based on the column name, search for specific names or search for a pattern of characters in the name.
Detail
The values to apply to the selection criteria. If the selection criteria is by column name, configure the string or name to search for. If the selection criteria is by port type, select the port types to include.
The following table describes the selection criteria and how to specify the details for the criteria:
Selection Criteria
Description
Detail
All
Includes all ports.
No details required.
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.
Type
Filters ports based on the data type of each port.
Select data types from a list.
Pattern
Filters ports by a string of characters in the name or by a regular expression.
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.
Complex Data Type Definition
Filters ports by a 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.

0 COMMENTS

We’d like to hear from you!