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?