I have as well faced the problem when we have composite primary key in the
table, so below is how have went with workaround.
deltaQuery retrieve concat value with time criteria (that should retrieves
only modified rows) and use it in deltaImportQuery with where clause.
On Sun, Jul 8, 2
Could you try something like this.?
deltaQuery="select CONCAT(cast(col1 as varchar(10)) , name) as ID FROM
MyTable WHERE UPDATED_DATE > '${dih.last_index_time}'"
deltaImportQuery="select CONCAT(cast(col1 as varchar(10)) , name) as ID, *
from MyTable WHERE CONCAT(cast(col1 as varchar(10)) , name) =
