How to perform Delta load without using target table?

[former_member214784]

Hi All,

I am trying to do delta load in sap bods 4.1(sap ECC to ORACLE),

my requirement :

I should do initial load and after that I should perform delta load,

But without using the target table (i.e without comparing target table with source) how can I perform this?

By,

Vinodh

[former_member187605 · Accepted solution]

For delta loads you can use (a combination of) source CDC (Change Data Capture) and target CDC.

Source CDC can be based on Sequence numbers, Last modification timestamps, Log tables (CDHDR and CDPOS in ECC)...

Target CDC is the only way to guarantee data consistency though. The DS Table_comparison transform is a very efficient mechanism for implementing target CDC.

[former_member214784 · Accepted solution]

Hi Dirk,

Thank you very much,

but as per my requirement I cant use the target table data for comparison.

please let me any other solution.

By

Vinodh

[former_member187605 · Accepted solution]

If you want to use target CDC without access to the target table, your only option is to maintain a copy of your target in a staging area. That's common practice e.g. for incremental loads into ECC.

[former_member214784 · Accepted solution]

Dirk,

I not using target based CDC,

let me know how to implement source based CDC without considering target...

by

vinodh

[former_member187605 · Accepted solution]

1/. Tables containing a last-modification-timestamp, e.g. VBAK:

     AEDAT >= $g_start_extraction  - extracts all sales documents modified since a certain date/time
     or
     AEDAT >= $g_start_extraction and AEDAT <= $g_end_extraction - extract all sales documents modified between 2 date/times

2/. Tables without a last-modification-timestamp, e.g. KNA1, can be joined with CDHDR and CDPOS:

          KNA1.KUNNR = CDHDR.OBJECTID and

          CDPOS.MANDANT = CDHDR.MANDANT and

          CDPOS.OBJECTCLAS = CDHDR.OBJECTCLAS and

          CDPOS.OBJECTID = CDHDR.OBJECTID and

          CDPOS.CHANGENR = CDHDR.CHANGENR

     and a similar condition applied:

          CDHDR.UDATE >= $g_end_extraction and

          (CDHDR.OBJECTCLAS = 'DEBI' or CDHDR.OBJECTCLAS = 'BPAR') and

          CDPOS.TABNAME = 'KNA1'

     - will extract all customers modified since a certain date/time

[venkataramana_paidi]

Hi Vinodh,

Without target table means we can achieve only source based CDC.   Means either log based or trigger based.   For ECC data extraction we can use extractors.   Extractors support CDC for ECC.

Try with extractors for data extraction . I think this is the choice for you without involving the target table.

Thanks & Regards,

Ramana.

[former_member214784]

Hi Venkata Ramana,

Thank you for good reply, I tried what you replied.

but we are using lower version of SAP ECC, so this is not supporting the delta,

please let me any other solution.

By

Vinodh