Does Teiid support for Oracle?
INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1;
Trying to use this in the update query in transformation editor.
It doesnt seem to work.
We do not have direct support for that syntax. The closest that we have is a simple merge command - DML Commands - Teiid 8.7 (draft) - Project Documentation Editor
Another option is to use a direct query procedure to issue the sql directly to the source.
Retrieving data ...