DSXchange

Hi,
Assume multiple files containing customer data comes from 10 countries. Each file contains exactly the same format. The same customer may exist in each file. But target should have only one record. The files may come any time. They must be processed immediately. So it is possible that two files need to be processed simultaneously.

a) Describe how you would handle the flow of jobs.
b) What are the job designs issues that you need to consider?
c) What are the Data processing issues that you need to consider


According for this kind of situation how to design the job pls let me know


Regards
V.J.Vengadeshwaran

V.J., didn't you post the same question in this thread? The way the question is phrased makes it look just like a test question or an interview question; neither of which are particularly liked on this site.
If this question is neither, then it would be worth discussing locking and concurrency, as those are the base issues involved here.

a) with my usual professionalism
b) compliance with customer's in-house standards
c) accuracy, auditability, recovery, efficiency