"Missing Value Keyword" in tDbOutput Talent

user_15138137 0
Viewed 74

I am building a job to insert data into a table from another table. I have added lookup for the destination table to ensure that insertion only happens if the record does not exist.

Approach I am using is:

tDbInput (Main) --> tDbInput (Lookup) --> tmap --> replicate --> tFileOutputDelimited, tDbOutput (both at the same time)

While running the job I getting error saying, "Missing Values Keyword". I ensured that the not null columns are being inserted and that the column name matches with the columns in the destination table in tmap output.

How do I resolve this?

talend etl
1 Answers

Check that the schema is replicated from the tmap to the t_DBOutput.
Also check the settings of the t_DBOutput.
Is it set on insert data ?

You can also check the generated code of the t_DBOutput to look for problems.

user_18028890
Related