Skip to Content
0
Former Member
Apr 22, 2014 at 02:06 PM

Is there a way to create dependency on the real-time jobs

20 Views

Hi,

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.

Thanks,

C