topic Re: insert count is more than the table record count in Talend Data Catalog

insert count is more than the table record count

sbxr — Sat, 16 Nov 2024 04:52:45 GMT

Hi,

when i am loading some source data the count of insert which is showing in the job is 12344 but when i check in target table it is 12340 why so?

Tagert is Mssqloutput.

Regards

Re: insert count is more than the table record count

Anonymous — Fri, 23 Aug 2019 13:37:06 GMT

Hi,

I had the same problem with an Hive table.

My source was a database but the data was not cleaned yet, meaning it could have line breaks (\n , \r or \r\n).

You should replace these values. I would recommend to investigate your source.

Kr,

Jvl7

Re: insert count is more than the table record count

Anonymous — Tue, 27 Aug 2019 04:43:58 GMT

Hello,

Please try to get the rejects link when right click the out put component to see if there are rows rejected by your Mssqloutput component?

Best regards

Sabrina

Re: insert count is more than the table record count

Anonymous — Tue, 27 Aug 2019 04:46:19 GMT

Hello,

Make sure that you un-check the "Die on error" option to enable it and for MSSQlOutput, the "Use Batch Size" in the Advanced Settings of component should also be unchecked. Then the rejects link can be chosen.

Best regards

Sabrina