We've BIAPPS 220.127.116.11
When I run the incremental process by Execution Plan with only one selected option "Analyze Truncated tables Only",
I see that some tasks work too long time.
For example "SIL_GLLinkageInformationGeneral" have a status "Running", although, in the details of this task I see that Informatica workflow of this task already terminated (DAC status is "completed").
I noticed that while "SIL_GLLinkageInformationGeneral" have a status "Running", in the data base the following SQL
SELECT COUNT(*) FROM W_GL_LINKAGE_INFORMATION_G
the questions are:
1. what is the functionality of running this SQL by DAC (I don't understand that, because SIL_GLLinkageInformationGeneral fill W_GL_LINKAGE_INFORMATION_G incrementally) ?
2. is the way to prevent the running of SELECT COUNT(*) FROM W_GL_LINKAGE_INFORMATION_G ?