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

Insert Else Update

Insert Else Update

Use the Insert Else Update property to update existing rows in the dynamic lookup cache when the row type is insert.
This property only applies to rows entering the Lookup transformation where the row type is insert. When a row of any other row type, such as update, enters the Lookup transformation, the
Insert Else Update
property has no effect on how the Integration Service handles the row.
When you select
Insert Else Update
and the row type entering the Lookup transformation is insert, the Integration Service inserts the row into the cache if it is new. If the row exists in the index cache but the data cache is different than the current row, the Integration Service updates the row in the data cache.
If you do not select
Insert Else Update
and the row type entering the Lookup transformation is insert, the Integration Service inserts the row into the cache if it is new, and makes no change to the cache if the row exists.
The following table describes how the Integration Service changes the lookup cache when the row type of the rows entering the Lookup transformation is insert:
Insert Else Update Option
Row Found in Cache
Data Cache is Different
Lookup Cache Result
NewLookupRow Value
Cleared - insert only
Yes
-
No change
0
Cleared - insert only
No
-
Insert
1
Selected
Yes
Yes
Update
21
Selected
Yes
No
No change
0
Selected
No
-
Insert
1

0 COMMENTS

We’d like to hear from you!