I am facing issue with the loading data to target table. We load using INFORMATICA tool(ETL tool ). While loading data in DEV & QA, it is taking not more than 5 mins to load 656528 records(insert).
But In PROD it is taking more than an hour. I checked for the indices o the table. Same in 3 environments. Is there something I am missing to check.
Kindly share your views, Thanks in advance.