#1 2010-06-30 16:39:22

anr
Member
Registered: 2010-06-24
Posts: 19

Data Synchronization

I have a data  synchronization case and i wanted to share it,  if any one can suggest some ideas it will be great,

my scenario is as follows.
I have 2 transactions let us say Trx A and Trx B to synchronized from System A to System B

System B has architecture whereby  Trx A will be synchronized to record A , but if Trx B happens before Trx A then Trx A to be synchronized to Record B(new).  simply the update record in the target system may vary based on the source transaction order.

I will be using a daily batch for transaction synchronization,  I will receive file A with Trx As and File B with Trx Bs. So based on some logic I wanted to read the records from both files chronologically and intermittently  and redirect them to target schema separately.

Is this can be handled in TOS, and how to?

Thank you
Anr

Offline

Board footer

Powered by FluxBB