Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using dynamic schema in my job, " Insert " option on data is working in the tTeradataOutput component , but when I am using the "Update" / "Insert or Update" options on data in tTeradataOutput component , I am getting error specifying - " Primary key not specified".
According to talend guide "Update" / "Insert or Update" is supported ty tTeradataOutput in dynamic schema.
Please if some one can help me out. Attaching the lline from documentation below:=>
"The dynamic schema feature can be used in the following modes: Insert; Update; Insert or update; Update or insert; Delete."
You will need to set an update key in your Advanced Settings under field options.
But as I specified the schema I am using is dynamic. How can I specify update key in advance setting.
Also its giving option to select for updation key columns only based on schema defined.
You will need an update key with the dynamic columns. What if your dynamic schema has multiple fields which *could* be a key? How does Talend identify the correct one?