Multiple files in Delta load

[tejasdikshit]

Hi All,

I have a couple of questions with respect to Delta Loads in SAP DI:

1. Can someone 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?
2. Also what does the naming for the file mean (highlighted in red)?
3. The __sequence_number field in the delta load is 'Null'. For reference, each delta load file shows only 1 single row . Any thoughts why the column in blank?

Thank you

[jimgiffin]

Tejas,

I'll try to answer your 3 points:

1) In delta mode - the system sends deltas in almost real-time from ABAP backends. This can lead to multiple files and allow you to pick up each file as deltas occur and not have to wait for the hourly "batch" to complete. While it is grouped in an hourly folder, it is not collected in an hourly file. However, if you want to collect/merge the files into a single file, DI has graphs to do that work too - see this link for the 4 options: https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/97fce0b6d93e490fadec7e7021e9016e/360f5276357945449d6...

2) The naming of the files is generated by the backend for the hour - in this scenario it is YYYYMMDDTHH.

3) If the backend system is ABAP the sequence number is not used - please see the help doc here: https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/1c1341f6911f4da5a35b191b40b426c8/12e0f97395424df4a60...

[jmuiruri]

Greetings tejasdikshit,

Where's the screenshot?

Best Regards,

Joseph

[tejasdikshit]

Apologies joseph_muiruri . I have attached it in the question

[jmuiruri]

Greetings tejasdikshit,

I see this is a DI problem and not SAP Data Services, could you please tag it correctly by removing the SAP Data Services tag as Data Intelligence and SAP Data Services are two completely different products.

Best Regards,

Joseph