Running for multiple countries [message #347437] |
Thu, 11 September 2008 11:45  |
gyankr
Messages: 11 Registered: January 2008
|
Junior Member |
|
|
We are trying to load some data from flat file to a particular table in our db.We are getting feeds separately for US and CA.
When the job for US runs it synchornizes the feed file with the db for US records and deactivates the records which do not exist in the feed file for US(Note the records for CA are untouched in the db).
The same applies for CA job.
The problem we are facing currently is the feed for US has some records for CA and this results in deactivation of missing records for CA in the db.
We do not want to deactivate records for CA even it exists in the feed while running the job for US,but we want the those set of records to be processed while running feed for CA.
The problem is where do i store those records for CA (make is persistant somewhere) and process them while running for CA
The same applies for feed in CA may have records for US which has to be processed while running feed for US.
Any thoughts?
Regards,
Gyan
|
|
|
|
|
|