What do the __DLH_ columns mean?
What do the __DLH_ columns mean?
DLH.io adds system-generated columns to each table in the Target Connection:
- __DLH_IS_DELETED - Indicates whether this record has been deleted in the source system.
- __DLH_SYNC_TS - Indicates when this record was synced into the target database.
- __DLH_START_TS - Indicates when this record started to be synced into the target database.
- __DLH_FINISH_TS - Indicates when this record finished being synced into the target database.
- __DLH_IS_ACTIVE - Indicates whether this record is the active record. When TRUE, this is the most current record available from the source system. When FALSE, a more recent record is available and the source system has CDC enabled.