I would raise a Service Request with Informatica Global Customer Support (GCS) to get an authoritative answer.
From my own experience I can say, I've never seen any differences between Standard Edition and Enterprise Edition, but then I'm no experienced Oracle programmer, and it may well be - assuming you have any mappings with complex SQL queries manually built - that you will face issues with these manually crafted SELECT statements; maybe they behave differently under SE and EE, I don't know (because this probably depends on the exact SELECT statements).
Personally I've never seen a case where SQL statements created by PowerCenter would behave differently on SE and EE, but I can't possibly know whether your environment uses any manually written SQL queries.
I just dare to assume that the Informatica platform doesn't care either, but GCS can tell you for sure, I can't.
2 of 2 people found this helpful
Oracle Standard Edition is supported but Engineering has certified our products against Oracle Enterprise Edition.
From Informatica perspective there is no difference how our software is working. There might be limitations on Oracle level but this would be a questions for Oracle.
Hope this helps.
The the type of oracle DB that youre using weather its standard or enterprise Is completely transparent to informatica.
As long as you can connect via SQL plus then PC will be able to do the same.
However as Asmita mentioned above
Oracle Standard edition is not certified with PC, nor do I know if it will be in the near future
Under normal circumstances once something is certified that means that with the Certification Process informatica had performed proper QA testing with those two products against each other. But without the Certification process, Informatica has not tested those two products together and can't possibly know what the outcome would be from attempting to run them together. This is not to say that is won't work, just that Informatica has not tried it in a proper official way and therefore dont know what would happen when you attempt to try to run in this type of configuration. So from a technical perspective I honestly dont think that you will have any problems.
I forgot to mention, you should always check the Informatica PAM to see exactly what is and what isn't supported.
Please let us know if you still have any questions