Symptom
When capturing the delta changes in local table, two additional columns (Change Date and Change Type) will be created automatically.
Column "Change Type" will change values such I, A, D, etc.
In this article meaning of these values will be explained.
Environment
SAP Datasphere
Resolution
Row Type | Delta Table Value |
Insert | I |
Update before image | B |
Update after image | U |
Delete with before image values | D |
Delete with OK values only | X |
Upsert / Autocorrect | A |
Initial Load | L |
Replace | R |
Truncate | T |
See Also
- SAP Datasphere Help Portal Capturing Delta Changes in Your Local Table
Keywords
delta changes, delta, change type, upsert, insert, truncate, replace, delete, Replication Flow, Delta Table , KBA , DS-DI-RF , Replication Flows , DS-DI , Data Integration/Data Builder , DS-DI-TAB , Table Persistency , DS-DI-RT , Remote Tables , Bug Filed
Product
SAP Datasphere all versions