Hi All,
I have developed a ODI (i.e version 12.2.1) mapping with 2 source table getting joined and then loaded into a targt table.
Simple CDC has setup in one of the source table and Custom SQL statement to override default code generation has been defined in other source table .
Two physical mapping has been created.One is for Initial load load and another one for Incremental load.
Journalized data option has unchecked in the Bulk load and for Incremental load Journalized data option has checked.
While executing the mapping for Initial load the query is execute properly .It includ the Custom SQL statement in the executation steps.
Whereas for Incremental load the Custom SQL statement is not picking up at the time of executation steps.It is selecting entire table.
Is there any way to picking up the Custom SQL statement in the above mentioned mapping scenario?
OR
Is it ODI limitation while configure CDC in table other table does not support Custom SQL statement ?
Please provide your expert advice for this issue.
Thanks,