People soft application has meta-data info and a table with login credentials in the PS schema. Now that PS schema has suffix P in prod and suffix D/T/A in LE how do we implement it? if we have script to preserve the metadata tables it will go into suffix D/T/A will that work as the PS schema is coming from prod which has suffix P.
Thanks for the update. but that will take off the delphix benefits as we end up spending time with export/import.
Yes I added a script to run as part of the post refresh to create synonyms and grant Lower environment schema to access the source schema objects via synonyms.
But unfortunately there are inbuilt peoplesoft process and custom written code which is trying to truncate temp tables but it cannot truncateas it will not work against synonym.
Now if we have different schema names across the environment then looks like it is not possible to make delphix work with peoplesoft.
Do you see any other options which we can use?