topic Not all files are getting loaded in target in Talend Studio

Not all files are getting loaded in target

A_San — Sat, 16 Nov 2024 04:49:28 GMT

I am trying to load 2 files - one with one record and other with 10 records. But only the file with 10 records are getting loaded. I am expecting to see 11 records. Attached my tFileInputdelimited details. Please let me know what am I missing.

Appreciate any help.

Re: Not all files are getting loaded in target

TRF — Thu, 29 Aug 2019 17:21:00 GMT

Share your tDBOutput settings.
As it is called twice, if you have a "delete or truncate before" operation, the result is normal.

Re: Not all files are getting loaded in target

A_San — Thu, 29 Aug 2019 17:24:19 GMT

Yes, I have a truncate operation.Attached the screenshot.

But how do I keep the truncate option and still load all the files in one batch?

I want the truncate to happen when I load the next set of files and not for every file in one batch run.

SS9.PNG

Re: Not all files are getting loaded in target

Anonymous — Thu, 29 Aug 2019 17:52:30 GMT

Put a tDbRow component before your file list and manually truncate the table. Then change your tDbOutput action on table to default instead of truncate

Re: Not all files are getting loaded in target

A_San — Thu, 29 Aug 2019 21:08:28 GMT

Yes, that worked. Thank you!