Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
Can you please help me with this ?
Hello,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina