Array Size - DTS Stage
Posted: Fri Mar 28, 2014 1:49 am
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
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