As part of our project, data is being loaded from one schema to another in the same DB. (Oracle 12c)
For incremental data (new records), we are using ODI CDC which have trigger on source table.
We are using ODIWaitForLogData component in ODI package and using Global row count, mapping is executed after 1000 records. (Global row count = 1000)
Our job is in production for last 3 months. But, from last month or so, jobs are failing once or twice a week on ODIWaitForLogData step with reason - Timeout occurred while connecting to Database.