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

Inserts and updates for insert rows

Inserts and updates for insert rows

You can configure how the
mapping
task handles inserts and updates to the cache for insert rows. To update existing rows in the dynamic lookup cache when the row type is insert, enable the
Insert Else Update
advanced property for the transformation.
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
mapping
task handles the row.
When you enable
Insert Else Update
and the row type entering the Lookup transformation is insert, the
mapping
task 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
mapping
task updates the row in the data cache.
If you do not enable
Insert Else Update
and the row type entering the Lookup transformation is insert, the
mapping
task 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
mapping
task 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
Disabled - insert only
Yes
-
No change
0
Disabled - insert only
No
-
Insert
1
Enabled
Yes
Yes
Update
2
Enabled
Yes
No
No change
0
Enabled
No
-
Insert
1