Badges

140 Points
6 Years
Top 10

User Activity

Almost 4 years ago
Answered a question: Oracle ICS vs ODI
Is your business a disconnected business? Aren't the legacy systems being synchronized? Is your cloud systems not being synchronized with on premisses-legacy systems? Does your business already have transactional systems such as ERP, CRM in the cloud? And you need to…
Almost 4 years ago
I totally agree with the points you mentioned.
Almost 4 years ago
In response to "reviewer746463 Item#1 - For all main objects in ODI, such as PKG, Interface/Mappings, Procedures, variable, KM there is a "version" tab/ kind of property of the object. Once you navigate in there, you will be able to see the following: "Created By":…
Almost 5 years ago
You can find more about the ODI history on the link : http://www.oracle.com/us/corporate/press/016802_EN
Almost 5 years ago
Hi Rodrigo, That is good to know those limitations on integrating ODI with EPM applications . In terms of the main RDBMS in the market I think ODI is quite good in providing the native drivers, when they don't we can find it and place on the ODI drivers folder and works…
Almost 5 years ago
Hi Brian, it is a nice review. About the room for improvement I saw you mentioned the error handling, in that aspect we handle that in packages when exceptions happens during the data flow / load for example, someone changes a column name in one of the table sources then…
Almost 5 years ago
I would like to add another comment about how hard it is to find documents and manuals on SAP BI products if you don't have a support account, or even a simple document or if you need to do an evaluation, a proof of concept of the product you need to pay, whereas if you…
Almost 5 years ago
ODI Infrastructure wise I think it comes down to the infrastructure and network team understanding what are required to run the tool smoothly , also having a proactive and helpful DBA who really understands the nature of a database for DW, essentially the difference and…
About 5 years ago
But one of the beauties of ODI is exactly that flexibility in integrating several different platforms/technology, for example, say you have a data source on SQL server database and your target database is Oracle and you want to apply a sql server function, in your interface…
About 5 years ago
Which platform/ Technology are you using as a target ?
About 5 years ago
That is true!! the integration with other Oracle products is great and enable several business functionalities, some of the examples I have seen and worked on are the integration of OBIEE and BPEL(SOA) with ODI, for example, when you have OBIEE in your environment one of…

About me

Big Data / Business Intelligence / Data Warehousing Solution Architecture and development.
Data Warehouse best Practices, DW optimization and performance enhancement (Slowly Changing Dimensions, Change-data-capture, Materialized views, partitioning techniques, Oracle database administration), Dimensional, relational and Object-Oriented data modeling.
Data Base performance tuning.
ETL process: Oracle Data Integrator(ODI 10g, 11g, 12c), Informatica Power Center, Microsoft SSIS
Data visualization: Oracle Business Intelligence Enterprise Edition(OBIEE 10g, 11g, 12c) and Microsoft Power BI

Interesting Projects and Accomplishments