Missing Service request

Question

Hello All, need assistance on one issue. i use hadoop for ETA job, every day cron job runs and pick all data, but the issue is once the job finish it will pull from one db and store the data in other db. but there were bunch of (service_request) rows are missing, so the data comes like 1st db-->2nd Db then cron jobs runs then data will come to 2nd db -->3rd db. The missing rows is available in 1st db, but not 2nd and 3rd db.

Any idea how to resolve this issue

Comments

Are you transferring data from the 1st DB to the next ones using any conditions or filters?

---

1st Db and 2nd DB maintained by others. once all data loaded in 2nd DB then i will use conditions for required column and get the data to 3rd DB. This process will be done by cron job.

---

Because 1st DB and 2nd DB maintained by others, maybe they are not sending the required data to the 2nd DB from the 1st DB. Please confirm that from the incharge.