Array Size - DTS Stage

[senthil_tcs]

Hello,

Need clarification on Array Size option in DTS Stage. Our job design is to read messages from queue, parse it and load the transaction into the target tables. DTS stage is used to ensure transaction control. The query is to understand if we give a value of 2,000 for Array Size, does it signify commit every 2,000 records or 2,000 transactions. In our case each transaction will translate into multiple records into multiple tables. Parent table will have 2,000 records (Say - Order) as we process 2,000 message for each run but child tables will have more than 2,000 (Say - Order Lineitem).

Thanks,
Senthil Kumar

[ray.wurlod]

Array size is merely the number of records transmitted at one burst. It should be calculated as the buffer or packet size divided by the estimated record size, rounded down to a whole number (ideally a multiple of two).

Number of records per commit (per transaction) is typically a separate property. Setting this to the same value as the array size, or some integer multiple thereof, is best practice because it avoids unnecessary overlaps.