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 use Incremental load functionality in SAC for Import Job, this will help you in Scheduling and subsequently queuing your jobs.

for more details please check the below link

Incremental Load

Regards,

Tarun Arora

[dasari_reddy_ext]

Hi Tarun,

Thank you for the reply.

When I'm creating a query it takes date as normal filter but not as incremental load, also in import setting incremental load option is not visible.

Any suggestions on this?

PS: we are doing this in classic model.

Regards,