Data transferred from Oracle to controller through Java Coding.Data flow from Oracle temp table to controller table xstagefact. After data gets inserted into xstagefact, a process triggered for batch id creation and validation as defined in import specification. Post validation the data gets inserted into xdb18.The entire process which usually takes 45 mins, however sometimes it takes 5 to 6 hr to complete and after optimization it get normal.Pls suggest how to find out the cause?
Have you tried with "track data" disabled in your import spec?
Track Data was already disabled. However the we have cleared the xstagefact table as auto delete was not enabled, and run optimization every week as a maintenance plan. The issue has not repeated for last 5 month.