Table of Contents

Search

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

0 COMMENTS

We’d like to hear from you!