Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Router transformation

Router transformation

The Router transformation is an active transformation that you can use to apply a condition to incoming data.
In a Router transformation,
Data Integration
uses a filter condition to evaluate each row of incoming data. It tests the conditions of each user-defined group before processing the default group. If a row meets more than one group filter condition,
Data Integration
passes the row multiple times. You can either drop rows that do not meet any of the conditions or route those rows to a default output group.
If you need to test the same input data based on multiple conditions, use a Router transformation in a mapping instead of creating multiple Filter transformations to perform the same task.
The following table compares the Router transformation to the Filter transformation:
Options
Router
Filter
Conditions
Test for multiple conditions in a single Router transformation
Test for one condition per Filter transformation
Handle rows that do not meet the condition
Route rows to the default output group or drop rows that do not meet the condition
Drop rows that do not meet the condition
Incoming data
Process once with a single Router transformation
Process in each Filter transformation
The following figure shows a mapping with a Router transformation that filters data based on region and routes it to a different target, either NA, EMEA, or APAC. The transformation routes data for other regions to the default target:
The mapping routes data from source "src_Countries" to the targets "t_NA," "t_EMEA," or "t_APAC" based on the region. The Router transformation routes data for all other regions to default target "t_Default."
To use the Router transformation, you need the appropriate license.