I've a job built to read data from Mongo to oracle table. If there are any rejected records due to some errors than they are loaded into a rejected table on Oracle Database.
Once, the issue is fixed, we want to process these records. Now, when we read the data from Mongo we are doing an incremental load. So, based on dates it gets the data from Mongo to oracle.
Now, if i want to read the data from Mongo for all the records that we have in rejected table on oracle, how do we do this ?
How can I use Oracle Table in the INNER JOIN when I'm reading data from Mongo. I want to get the data from Mongo for these records separately.
