Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ultron
Contributor
Contributor

How to use "Insert or Uptade" option on data in tteradataoutput, while using the dynamic schema for the component.

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."

Labels (2)
3 Replies
Anonymous
Not applicable

You will need to set an update key in your Advanced Settings under field options.

Ultron
Contributor
Contributor
Author

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.

Anonymous
Not applicable

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?