Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  17. Datatype Reference
  18. Configure the Web Browser



A source contains orders for several cities. You want to write orders to separate output files based on the city.
The following figure shows a mapping to process the orders:
In addition to a source and Source Qualifier, the mapping has the following objects:
  • Sorter transformation
    . Sorts the source data by city.
  • Expression transformation.
    Determines when a new city appears in a row and passes an integer to the New City port of the Transaction Control transformation. Passes 0 by default and passes 1 when the row contains a new city.
  • Transaction Control transformation.
    Evaluates the New City value from the Expression transformation. When New City is 1, the Transaction Control transformation commits all orders in the transaction to the target. The Transaction Control transformation passes the city and order number to the flat file target. It also passes the city to the FileName column in the target.
  • Flat file target.
    Writes a new flat file for each transaction. The Integration Service names each target with the value of FileName.
The Integration Services passes a transaction for each city to the target. For this example, the data contains the following cities and order numbers:
Brisbane, 100 San Francisco, 101 San Francisco, 104 San Francisco, 105 San Francisco,107 Tiburon, 102 Tiburon, 106 Tiburon, 102
The Integration Service generates the following output files:
Brisbane San Francisco Tiburon

Updated June 25, 2018