I have am using teradata connector stage as target and i am deleting record table based on below condition
ELETE
FROM test
WHERE (A = ORCHESTRATE.A
AND C = ORCHESTRATE.C
AND S = ORCHESTRATE.S
AND S = ORCHESTRATE.S
AND G = ORCHESTRATE.G
AND CRA = ORCHESTRATE.CRA)
I am getting below warning
Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
there are no record for deletion but I want to know why this warning is coming.
the access ethod is immediate.
primary index of table test is on col A
The schema reconcilation options won't get rid of that warning. That warning occurs when you specify the SQL yourself without using the Build button. The warning is harmless. You can ignore it.