File Processing Methodology
I have the following requirement from the customer.
They would be appending record by record every minute in the same file and XI needs to process them into ECC.
Is this possible since file locking mechanisms will create problems.
The customer mentioned that they will look for the file while writing with the same name and if not found, will create new file with the same name.
Since this would cause real problems or incomplete records, I had advised them to create separate file for each record since the volume of records is just 20 or 30 per day.
Other option ihad recommended is to create them the file in .tmp and rename them to original filename after fully written. This will ensure that XI always picks up complete files.
Though this approach is good, the customer is reluctant to do the changes on their side.
Let me know whether there are any other alternative solution for this apporach.
Please note that the volume and size is pretty low which is less than 250kb file.