Explain the functionality of 'After ETL'. How is it processed?
Functionality of After ETL Implementation: One quartz thread will be created at the start of the Tomcat. This thread will start running from midnight 12:00 AM till it finds the ETL status as YES for every 15 minutes. It will check the table AFTER_ETL_STATUS (residing in WH DB) for the column ?ETL_COMPLETED?. Once it finds the status as Y, the thread will change the ETL status to N and start firing after ETL jobs. After firing all the jobs it will create another thread which will start running from next day midnight and the existing thread will henceforth stop. One of the reasons for receiving the report prior to ETL completion might be because of this thread being altered to 'Y' status manually and the other one being tomcat not being restarted frequently. It is always recommended that for the overall functioning of ARC and quartz jobs, Tomcat has to be frequently restarted as per the usage as part of the overall maintenance.