Posted by Dylan Wan on March 30, 2007
Knowledge Module can determine how the data will be loaded from the source to the target database. Each Knowledge Module is a text based template that is used to generate the codes. It includes the skeleton, which can be in any language or technology. For example, if I select “Oracle SQL loader” LKM, ODI will generate the loader scripts. If I choose “External Table”, it generate the Insert and select statement using the external table feature.
Knowledge Module isolates the logical mapping from the different technology, so the mapping can be used from different platforms and DBMS systems. At the design time, I can specify which knowledge I want to use by the drag and drop interface. At the run time, the tool will use the Knowledge Module I specify, and dynamically generate the codes and process the job. I feel that it is very powerful and is the key component for ODI to support the hetergenious environment.
We can add our own knowledge module for the reusable components, opportunities for partnerships.
Posted in Oracle, Oracle Data Integrator, Sunopsis | 1 Comment »
Posted by Dylan Wan on March 26, 2007
Posted in Oracle | No Comments »
Posted by Dylan Wan on March 14, 2007
I think that it is important to understand why a single view of customer important. Understanding this provides you a good perspective on why you should implement a MDM, or a CDI, solution.
I believe that a data warehouse deployment will be much easier and simplier if we can assume a MDM is in place. However it requires some design efforts to leverage MDM in data warehouse data model and ETL design.
Read the rest of this entry »
Posted in CDI, Customer Data Integration, MDM, Master Data Management | No Comments »
Posted by Dylan Wan on March 14, 2007
Master Data Management is a combination of business processes, software application, and technologies which helps you to manage your master data, such as “Customer”, “Supplier”, “Employee”, and “Product”.
There are four key components of a MDM solution… Read the rest of this entry »
Posted in MDM, Master Data Management | No Comments »
Posted by Dylan Wan on March 5, 2007
Backlog refers to unfinished work or to customer orders that have been received but are either incomplete or in the process of completion. Backlog orders are also known as Open Orders.
Backlog analysis lets you to investigate the potential revenue by reporting all the work that have been received but not yet fulfilled. If you assume that you can fulfill all the remaining work in your backlog, you can predict how much revenue you will generate over the remaining period. Read the rest of this entry »
Posted in BI Application, Business Intelligence, Project Intelligence, Sales Intelligence, Supply Chain Intelligence | No Comments »
Posted by Dylan Wan on March 5, 2007
Up-sell and cross-sell are important for your business due to the increasing competitions and market volatility. You need to maximize your customer value by selling more to your existing customers. Up-sell and cross-sell are key drivers of deploying a business intelligence analytical application, which can help you identify new source of revenues.
Up-Sell and Cross-sell are defined as below: Read the rest of this entry »
Posted in BI, BI Application, Marketing Intelligence, Sales Intelligence | No Comments »
Posted by Dylan Wan on March 4, 2007
Conformed Dimension is a concept coming from dimensional modeling. I believe that Conformed Dimension is one of the original source where the customer data integration and master data management come from.
Read the rest of this entry »
Posted in Data Warehouse, ETL, MDM | No Comments »
Posted by Dylan Wan on March 2, 2007
This is the link to public available Business Intelligence Suite Enterprise Edition Version 10.1.3.2 Documentation Library. Read the rest of this entry »
Posted in BI Links, Business Intelligence, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | 2 Comments »
Posted by Dylan Wan on March 1, 2007
Posted in hyperion | No Comments »
