ETL Performance Troubleshooting

Performance of Informatica ETLs might slow down over time due to the increased number of records in the HDI_ETL_EXCPTN_LOG_G table. To improve HDI to HDM ETLs performance, it is recommended to partition the HDI_ETL_EXCPTN_LOG_G and HDI_ETL_EXCPTN_LOG_TMP by running SQL statements provided in the scripts below manually one at a time.

1. Navigate to the directory:

   <OHF_INSTALLER_ZIP>/Disk1/stage/Components/oracle.hsgbu.hc.dma.infa/8.2.5.0.0/1/DataFiles/Expanded/filegroup1

2. Unzip dma_infa_master_install.zip
3. Use the following script:

   @OHF_Install_Home/dma_infa_master_install/hmc_infa_install/wil_hmc_HDI_ETL_EXCPTN_LOG_tables_online_partition.sql