Submitted by foxknight on Jun 03, 2018
Submitted by foxknight on Jun 03, 2018

It would be nice to have a Pre/Post SQL option similar to other ETL tools in the market to handle some of this nuances. Just a thought!!

Submitted by foxknight on Jun 03, 2018

Thanks for your input. We will gladly consider this in future releases.

A workaround to stage any source that has duplicates is to land the source data as is using truncate and reload or Append CDC type. While truncate & reload truncates target land table, append keeps on inserting source data into target table.

Submitted by foxknight on Jun 03, 2018

Test here