Multiple files in Initial and Delta load

[tejasdikshit]

Hi,

In SAP Data Intelligence I am doing the RMS replication method to move data between S4 and ADL using CDS views. When I create a task for a specific table it creates multiple files under the initial load and delta load folders. ( See screenshot below). Any thoughts why? I am grouping the delta by hour and Suppress Duplicates is 'True'

[tejasdikshit]

Hi nikhil_16 ,

Thank you for your assistance. Can you help me understand why does delta load create multiple files with relatively small sizes in RMS( see screenshot below) for record changes happening within a single hour. I have mentioned Group By= Hour. Is there a way to eliminate this issue and have only 1 file created for all records updated within a given hour?

Also what does the naming for the file mean ( highlighted in red)?

Thank you

[NikhilD · Accepted solution]

RMS breaks down the records into multiple files

Refer to the Cloud Storage Target Structure

https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/1c1341f6911f4da5a35b191b40b426c8/12e0f97395424df4a60...

You can use graphs to merge the files. Refer to the link

https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/97fce0b6d93e490fadec7e7021e9016e/360f5276357945449d6...