There exists a situation where a same named file is resent to DPV-ETL a number of times, each with a different run number and different data. There is a mechanism that provides for incremental renaming of files before processing, but if the files arrive too slow, they are moved to SUCCESS or FAILED, and the incremental renaming no longer applies. What are the naming rules applied to data files in the DPV-ETL?
>> When transferring a file using Remote Transfer Agent: If the file already exists in the Device (to be processed) folder, then a ###nn is appended to the file name (before the .extension), else the file is transferred with the original name. Here the nn is a number from 1 to 9999. The number is determined as the lowest number that does not have an existing file by that name in the to-be-processed folder.
>> Regarding the Success and Failed folders: In the case of a file being moved to the FAILED or SUCCESS directory after processing; File renaming (as described by ###nn above) only happens in the to-be-processed folder. If a file with the same name already exists in the FAILED or SUCCESS directory, it is overwritten. That is; only the latest copy of the file is present in the SUCCESS or FAILED directories.
Notes