Business Integration (BI) combines two parts: one is to build a data warehouse, the other is to build a visual report for the end user and stakeholder to help make business decisions. Traditionally, in BI we mostly use a relational database (RDBMS) like Oracle, Microsoft SQL Server, IBM DB2, My SQL and so on. For a […]
Jacky Yang
Blogs from this Author
How to Facilitate Multiple Oracle Services in One Linux Server
Docker is an open platform that gives customers the ability to deploy multiple o/s containers on any give host. This allows for the deployment of multiple environments without having to incur the overhead of having a virtual machine for each environment. Docker uses Linux o/s facilities like namespaces, groups and union capable file systems to […]
Informatica+PowerExchange Introduction
Most of the enterprise data warehouse using Informatica PowerCenter to build the warehouse. After build the data warehouse and make it incremental load daily or several time per day. But data warehouse is not real time, it also has some gap between the source database and Target database. How can we make Data Warehouse Real […]