I am trying to use Push down optimization on teradata database.
while informatica is creating a merge sql, getting the error (The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT).
one of the column in the target table is partitioned and the merge statement is trying to update the partition column, which i believe is causing the error.
And the partition column is on date field, which may be changed on a primary key.
so, please can anyone advice on this.