What do the __DLH_ columns mean?

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.

    • Related Articles

    • What is DLH.io?

      Getting Started What is DLH.io ? DLH.io documentation for What is DLH.io ? Whenever you need to get data into a single source of truth, transform it, or manage it, DLH.io (aka DLH.io) is one of the first steps in that journey. Answering the question ...

    • What are the DLH.io Pre-Built Data Models?

      Learn The Basic Concepts What are the DLH.io Pre-Built Data Models? DLH.io documentation for What are the DLH.io Pre-Built Data Models? Analytics models are a accelerators for data warehouse and data vault models that allow any organization to start ...

    • What types of changes are handled and tracked by DLH.io?

      What types of changes or metadata changes from source to target are handled and tracked by DLH.io? DLH.io handles the following types of changes from source systems: Change Data Capture (CDC) Change Tracking (CT) Metadata Additions - e.g., ...

    • Getting Started with DLH.io

      Getting Started ? DLH.io documentation for Getting Started ? Why DLH.io: Because it is a proven accelerator to delivering intelligence to any organization that uses data to make business decisions. The DLH platform provides end-to-end data ...

    • What types of changes are NOT handled by DLH.io?

      What types of changes or metadata changes are NOT handled by DLH.io? DLH.io does not handle deletions for structural source system metadata. For example, if a customer has a source like a PostgreSQL database and synchronizes a set of database tables ...