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

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!