We decided to go with the supported verison of 9.6.0. But if someone has been using DAC 11G with informatica 10, I would like to know how it is working. Thanks!

Thank you very much for the link. Based on that matrix, we have OBIA 7.9.6.4 and looks like Powercenter 9.6.1 is the certified version. We are in the process of upgrading our informatica footprint. I would like to know if the latest powercenter verions 10.1 work with our current stack of OBIA 7.9.6.4, DAC 11g and Oracle…

yes, adding hints to some long running jobs helped and adding additional resources helped to finish the jobs. Our major constraint is the resources allocated to the lower environments. the resourses are allocated based on incremental load, since 90% of the time we load only incremental data. so I'm exploring the…

yes, I tried to idnetify and tune long running jobs, but the data has grown so large that it takes weeks to complete the load. secondly, since we never do a full load in prod, this does not help in any way and we have to add extra storage (mainly staging and informatica temp space) and processor to load this data in lower…