Dylan's Notes on BI, Data Warehousing, and Online Analytical Process
Dylan's Notes on BI, Data Warehousing, and Online Analytical Process Recent Blog Posts
BI Apps 7.9.6.1 is released
on Oct 13, 2009 in Business Intelligence Here is the press release from Oracle: Oracle Introduces New Release of Oracle® Business Intelligence Applications This change over the release 7.9.6 is that it is certified with Teradata, MS SQL, and DB2. Also, it includes the performance tuning o...
BI Apps 7.9.6 is out
on May 14, 2009 in Business Intelligence Here is the press release. This is a very important release for customers. Several new features are introduced: Party Model Multiple Calendar Model Multiple Product Categories UOM Conversion Country Dimension Posted in Business Intelligence...
Informatica ETL Tuning Steps
on Mar 14, 2009 in Business Intelligence ETL Infomatica OBIA First, we need to identify where the performance problem come from. The bottleneck can be: Source Extract Transformation Lookup Target Write I will talk about how to isolate the problems and go over each about how to investigate the problem in...
Data Security in Oracle BI Apps
on Jul 14, 2008 in BI BI Application BI Work Business Intelligence OBIA OBIEE Oracle Oracle BI Suite EE Siebel Analytics data security I am describing how data security works in Oracle BI Apps. The key concept is that Oracle BI Apps can read the permission/grant the security administrator defined in the OLTP during the runtime. If you change/revoke the access in OLTP, the change...
Use ANSI SQL for Outer Join
on Jul 3, 2008 in BI BI Application BI Work ETL Infomatica Oracle Oracle Data Integrator The OLTP source applications like PeopleSoft and Siebel applications can run on many different databases including Oracle, MS SQL, or DB2. The target data warehouse can also run on different database platforms, incluidng the above databases, plus Te...
Use SQL*Loader with Named Pipe
on Jun 23, 2008 in BI BI Work Business Intelligence Data Warehouse ETL Infomatica Oracle Oracle Data Integrator Sunopsis ODI SQLLDR Typically using SQL*Loader assumes that a flat file will be used as the input. The file will need to be created and generated before the SQL*Loader can take the data from the file and load the data into Oracle. The performance can be improved and t...