Where can you simultaneously define primary keys for the Update and Delete operations in a tMysqlOutput component?

Where can you simultaneously define primary keys for the Update and Delete operations in a tMysqlOutput component?
A . Basic settings view, select the Use field options check box
B . Advanced settings view, select the Additional columns options check box
C . Advanced settings view, select the Use field options check box
D . Advanced settings view, select the Use hint options check box

View Answer

Answer: C

Explanation:

The tMysqlOutput component is used to write data into a MySQL database table. The Update and Delete operations are used to modify or remove existing rows in the table based on a primary key. To define the primary key for these operations, you need to use the Use field options check box in the Advanced settings view of the component. This will enable you to specify which columns are used as keys for each operation. You can also define other options for each column, such as nullable, length, precision, etc. The Use field options check box is not available in the Basic settings view of the component. The Additional columns options check box and the Use hint options check box are used for other purposes, such as adding extra columns or hints to the SQL query, and they do not affect the primary key definition.

Reference: Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [tMysqlOutput properties – 7.3]