ODI is an ETL tool. It has two main advantages over competing products:
1) It uses an ELT type approach, i.e. all of the transformations happen on the target datawarehouse server in SQL. This means that ODI is not a black box and developers know exactly what is going on. This is great for debugging. It also means that ODI can leverage the horse power of the target warehouse server and does not require any additional application servers like traditional ETL tools, Informatica etc. It lowers the TCO.
2) The main advantage of ODI over competitive products is the code template approach. This guarantees extreme reusability of your and your developer's ETL code. Data transformation logic and strategies are encapsulated in so called Knowledge Modules and can be reused across your data warehouse. This may cut down development time by 30-50%.
Links to ODI tutorials can be found on the BI Quotient blog
951
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
