I am running the full extract process , and one task SDE_ORA_InventoryProductDimension running for 18 hours and its status is "Waiting for the previously running task to complete"
but all running tasked are completed and left tasks are queued by this task, so what make this issue happen?
I restart the informatica server and the task running now!
but for this task I run before it has ten million records , and it always make the dataware house server's cache full and server down,
so how to handle this problem?
Edited by: Yu Yang on Apr 16, 2013 4:58 AM
Check if /*+ FULL(PER_ALL_PEOPLE_F) */ hint existed in the SDE_ORA_INVENTORYPRODUCTDIMENSION_FULL mapping Source qualifier?.
I suggest you to raise an SR and check with your DBA's if they can do something to improve the Performance.
Mark helpfull if it helps.