Table of Contents

Search

  1. Preface
  2. Working with Transformations
  3. Aggregator Transformation
  4. Custom Transformation
  5. Custom Transformation Functions
  6. Data Masking Transformation
  7. Data Masking Examples
  8. Expression Transformation
  9. External Procedure Transformation
  10. Filter Transformation
  11. HTTP Transformation
  12. Identity Resolution Transformation
  13. Java Transformation
  14. Java Transformation API Reference
  15. Java Expressions
  16. Java Transformation Example
  17. Joiner Transformation
  18. Lookup Transformation
  19. Lookup Caches
  20. Dynamic Lookup Cache
  21. Normalizer Transformation
  22. Rank Transformation
  23. Router Transformation
  24. Sequence Generator Transformation
  25. Sorter Transformation
  26. Source Qualifier Transformation
  27. SQL Transformation
  28. Using the SQL Transformation in a Mapping
  29. Stored Procedure Transformation
  30. Transaction Control Transformation
  31. Union Transformation
  32. Unstructured Data Transformation
  33. Update Strategy Transformation
  34. XML Transformations

Transformation Guide

Transformation Guide

Connected Lookups

Connected Lookups

A connected Lookup transformation is a Lookup transformation that is connected to a source or target in a mapping.
When you run a mapping that contains a connected Lookup transformation, the Integration Service performs the following steps:
  1. The Integration Service passes values from another transformation to input ports in the Lookup transformation.
  2. For each input row, the Integration Service queries the lookup source or cache based on the lookup ports and the lookup condition in the transformation.
  3. If the transformation is uncached or uses a static cache, the Integration Service returns values from the lookup query.
    If the transformation uses a dynamic cache, the Integration Service inserts the row into the cache when it does not find the row in the cache. When the Integration Service finds the row in the cache, it updates the row in the cache or leaves it unchanged. It flags the row as insert, update, or no change.
  4. The Integration Service returns data from the query and passes it to the next transformation in the mapping.
    If the transformation uses a dynamic cache, you can pass rows to a Filter or Router transformation to filter new rows to the target.
This chapter discusses connected Lookup transformations unless otherwise specified.

0 COMMENTS

We’d like to hear from you!