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 ?
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.
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.
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.
