Any thoughts? suggestions?
ODI is Oracle's strategic ETL tool and as such will almost always have richer native integration with Oracle owned products such as the EPM suite built into its framework. That's not saying you cannot build the integrations you require with Informatica but it will certainly require more development work and may be more difficult to maintain through various product versions as features change e.g. are the Hyperion Informatica Essbase adapters compatible with the version of Power Centre you are running etc. You could write a whole essay on the other benefits of ODI vs Informatica but I'm sure the Oracle sales literature will cover that off. So to answer your questions specifically:
1) Yes if you want to centralise all your ETL in a common tool. No if you want to use an ETL tool that has better support for your target applications.
2) Yes you will lose ODI functionality such as reversing data models etc but that is not to say Informatica will not do what you need it just does it differently and perhaps not as elegantly as ODI
Thanks for your response.
Our plan is not to use INF connectors but use INF as much possible to prepare data as part of ETL then use Load rules/sql data load option to load into Hyperion. Only worry is preparing the dimensions Metadata updates and setting its properties. Currently we use ODI to prepare a metadata delta file with required properties using related KM's and load.