We are planning to implement BI Apps 7.9.6. I see in the installation document that Informatica PowerCenter is needed for ETL Jobs? Do we need to license Informatica for this? Can anyone tell me if Informatica is the only way? I know we can use ODI but its in version 220.127.116.11
To leverage the prebuilt mappings you will use an oem version of informatica for this, you can get it off oracle edelivery and there is a licence key included in the install package.
As far as I am aware the BI apps licensing includes the DAC and the oem Informatica product with the pre built mappings.
The licence for informatica is limited in terms of your target db to one instance.
For a details breakdown of costs you should ask your local oracle sales rep for a quote where they break it down between obiee, apps and informatica costs according to your number of users, hardware etc.