SAC Import Job Partitioning.

[dasari_reddy_ext]

Hi All,

We are creating Model in SAP using SQL database. as we know the limit for importing data is 10000000 rows at a time. We have much more data than that. So we are using import jobs for the same but we need to schedule jobs to make loads automatic. Do we have a option of partitioning for import job in SAC? similar to what we have in DWC for table replication.

PS: We know about filtering on query but the question is can we do the partitioning on Import Job?

Regards,

[TarunArora]

Hi Jagan

Please see attached, Use the DataMangement-->Import Settings-->Incremental Load & Add Data Filter.

Hope this help.

Regards,

Tarun Arora

importjob-deltaload.png

[dasari_reddy_ext]

Hi tarun.arora

Thank you for your answer.

I tried but still the Data Management tab is not available for my Model based on SQL data source i.e. Snowflake.

But for another models based on OData service and one on BW as a backend, Incremental Load option is visible for them.
Is Incremental filter does not get applied on SQL based Models?

Regards,