Table of Contents

Search

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

Developer Mapping Guide

Developer Mapping Guide

Example - Reorder Generated Ports

Example - Reorder Generated Ports

An employee flat file source has many columns that change frequently. You want to sort the employees by name and view the employee data in a way that the employee names appear in the first column followed by the city where the employees work. You also want to move the columns that are of type decimal to the end because you do not want to analyze the data for those columns.
The following image shows the dynamic port From_Read_EMPLOYEE with the original order of generated ports:
The mapping contains a Read transformation and a Sorter transformation. The generated ports in the Sorter transformation appear in the same order as they appear in the Read transformation.
You configure the following input rules:
  • Include ports by "name" and "city."
  • Include all ports by string type.
  • Include all ports by decimal type.
Then, you choose to reorder the ports based on the input rule order. To verify the order, you can preview the port order.
The following image shows the order of the input rules:
The Input Rules dialog box shows three input rules defined in the Include or Exclude Ports area. The first rule is to include the ports name and city, the second rule is to include all ports by type string, and the third rule is to include all ports by type decimal. The Reorder generated ports according to the input rule order option in the Settings area is selected. Port Preview area displays the generated ports according to the input rule order.
The following image shows the reordered generated ports based on the input rules settings.
The mapping contains a Read transformation and a Sorter transformation. The generated ports in the Sorter transformation appear according to the input rule order.

0 COMMENTS

We’d like to hear from you!