cancel
Showing results for 
Search instead for 
Did you mean: 

Delta load into SAP Analytics cloud

kalpesh_pandey
Contributor
0 Kudos

Hi, I am planning a product for a small business. The data size can be 20-30 GB in 10-15 tables. But delta every day will be in a few hundred MB every day. I am planning to export all data in files or can connect to tables directly. Once I load Initial data into SAP Analytics cloud then I am planning to load delta every day. I know we can sync SAC but can we load the only delta. I am still looking into this but thought if experts can guide me on this.

Thanks,

Kalpesh

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi,

If you are looking for delta loads for transaction data, you can use incremental loads option. But you should have a date field in the source tables.

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/0e48b89d83a943cb9e8d68e1e...

Regards,

Sankar

Prabhith
Active Contributor
0 Kudos

Hello kalpesh.pandey ,

While loading to a model, you have the following options.

Will any of this option help you in deriving your delta's?

Note: This is not available for Public dimensions. Its 'Update' by default there.

BR, Prabhith