APD - Input Query partitioning

[Former Member]

Hi all!

We currently designing an APD process with an input query that will deliver approx. 1M rows. On the second properties tab (Extended Setting) of the Input Query , an option is offered which should permit some kind of partitioning. Unfortunately this option is not documented. Do you have any experiences or a more detailed description of how it works ?

Any information is well appreciated.

Regards, Philipp

[former_member188975]

Hi Philipp,

You can check note 751577:

You can use the partitioning available as of BW 3.20 to solve memory overflows. There, you can select a partitioning characteristic. For example, you can use it to create settings that determine that the system executes a query for each product group instead of a query covering all product groups. This reduces the consumption of memory because the system no longer

loads all the data into the main memory at the same time.

Hope this helps...