| Description |
For environments with high-availability setup, it is preferred to
use the SSISDB compilation type for its failover capabilities. However, note that the
extraction of SSISDB packages are much slower than packages stored in MSDB. Beginning
with DWD 11.3.1 HF20, to optimize SSISDB executions, all extraction steps can now be
executed asynchronously before all transformations. An additional job step is added to
check all SSISDB package execution status. If there are errors encountered during the
extractions, the transformation steps will not proceed. This applies to single-thread
ETL processing only. |
| Impact |
Users using the SSISDB compilation type in their DWD profile now
have the option to extract their SSIS packages asynchronously. |
| Related JTs |
JT-1223415 |
| Related Documents |
Infor Business Vault Data Warehouse Designer
Administration Guide |