Initial load and Incremental load

[Former Member]

Hi all,

    How to perform initial load and incremental load .

    For incremental load I have to use table comparison transform??

Thank you.

[former_member187605 · Accepted solution]

I use Table_Comparison for all incremental loads where updates to the source are possible.

If you only have inserts, you perform CDC at source level (based on a timestamp, sequence number....) and don't need the Table_Comparison transform.

[Former Member · Accepted solution]

Thank you dirk

[jessie_wu01 · Accepted solution]

Hi Dirk,

Can you explain more about CDC? I am totally new to the data service.

Thanks,

Jessie

[former_member187605 · Accepted solution]

https://en.wikipedia.org/wiki/Change_data_capture