topic Re: Reject File in update db in Talend Studio

Reject File in update db

mani1304 — Thu, 01 Aug 2019 08:41:23 GMT

Hi,
I want to update some fields in database table from the input file based on some conditions and want to get the rejects in a file, means if a record, which is coming from the input file and not present in db, then it should move to the reject file, but this is not happening.
Can someone suggest how this reject works in db component table and how my requirement can be fulfilled ?

Re: Reject File in update db

Anonymous — Fri, 02 Aug 2019 09:24:26 GMT

Hello,

What's your target DB? Please un-check the "Die on error" and the "Use Batch Size" in the Advanced Settings of component. After that, you will get the rejects link when right click the output DB component.

Best regards

Sabrina

Re: Reject File in update db

mani1304 — Fri, 02 Aug 2019 09:33:45 GMT

That all is already setup, I have reject file from oracle db, but I am not getting how rejects works in Talend DI.

My requirement is if a record coming from input file is not present in db, then it should move to reject. Ab Initio works like this, but in talend, this is not happening. Although it's not doing any update operation in the db if input record is not present in database, that is expected, but that record is not moving to reject and this is what I am looking for.

Re: Reject File in update db

mani1304 — Tue, 06 Aug 2019 07:21:07 GMT

Can someone suggest ?

Re: Reject File in update db

Anonymous — Tue, 06 Aug 2019 10:09:18 GMT

Hello,

The "Reject rows" from output DB is used to gather data that could not be processed (wrong type, undefined null value, unparseable dates, etc.).

From your description, it looks like you are looking for changed data or modified data between source and target tables.

If so, you could compare your two tables in tMap component.

Target DB-->tMap(make inner join on your inputs and set the "Catch lookup inner join reject" as true)-->output

Source DB-->
The output will be the changed data.

Here is a CDC feature in talend subscription solution which can capture the data changes in the source table, and then you are able to synchronize these change data to target application.

Best regards

Sabrina

Best regards

Sabrina