I am involved in a retail project, and for requirments from of business we have to upload every day two files from each one of POS (point of sales) from 2,000 storages. the size for those files is not up to 7 kb, the real problem is that until today I cannot find a solution to upload this 4,000 files daily.
Let me mentioned, each one of these files are upload to a different cube.
I made some test tried to append the files, creating a one files for each one, that´s was ok, but the test just is using 24 files.
Of course the flat files are on application server and from there are uploaded.
I hope that some of you can help me with some alternative.