We have around 80 real-time services running and loading the changed data into the target.
The process being used is
IBM Informix > IBM CDC > JMS (xml messages) > DS real-time services > Oracle EDW.
While using the above process, when ever there is change in the fact table and the dimension table, both the real-time services are loading the data at the same time into the target. This is causing issues in looking up data with the timing issue.
Is there a way where we can create a dependency and resolve the timing issue and make sure the lookup table is loaded and then the master table is loaded?
Please let me know.