Strictly based on my experience with Informatica and DataStage, I find Informatica PowerCenter sufficiently advanced in ETL capability terms. As Informatica proclaims to be leader in data integration, the tool inherently is not designed for reporting requirements. However…
Thanks Gary for the details I missed to include. Indeed the cost, skill and maintenance of licensed tool is the make-or-break factor while deciding which tool to opt for, often realized through experience over period of time.
Data Integration systems, I would assume, are not referring to messaging and EAI here. For non-messaging or non-EAI Data Integration systems, I would look for these features
01. Range of built-in components available to transform data.
02. Degree of customization possible…
I used both products rather briefly. In my experience, OBIEE is better product than MSBI. While both products have limitations in ETL, reporting performance is better in OBIEE. Further, Oracle has proven credentials in handling large volumes of data, whereas MS SQL Server…
