Yes, that should work fine.
PowerCenter doesn't care whether those DB schemas are in different database instances or whether they are just different schemas within the same database. That should work fine either way.
What issues do you encounter with this setup?
I was getting error similar to the one refered in the blog.
My exact error is as below
[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002] Cannot create the domain because of the following error: [PERSISTENCEAPI_030
7] [PERSISTENCECOMMON_0001] Internal error. The request processing failed. This was caused by [PERSISTENCEAPI_0307] [DBPERSISTER_2002] The Repository Service
failed to create the repository content. This was caused by [informatica][Oracle JDBC Driver][Oracle]ORA-01658: unable to create INITIAL extent for segment in
1 of 1 people found this helpful
This is the tablespace issue in the database. Please refer below link
Contact your DBA for further assistance.