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 the disk space can be saved if you use named pipe with SQL*Loader.
Archive for June, 2008
Use SQL*Loader with Named Pipe
Posted by Dylan Wan on June 24, 2008
Posted in BI, BI Work, Business Intelligence, Data Warehouse, ETL, Infomatica, Oracle, Oracle Data Integrator, Sunopsis | Tagged: ODI, Oracle, SQLLDR | 1 Comment »
Hyperion Essbase Dimension Terminology
Posted by Dylan Wan on June 20, 2008
I found the the language used in Hyperion Essbase documentation is very useful for describing the dimension hierarchy. To communicate effectively, sometime we need precise teams to describe things. The terms defined in the Hyperion Essbase documentation helps.
Posted in BI, Business Intelligence, Oracle, PeopleSoft, essbase, hyperion | Tagged: essbase, hyperion, OLAP, Oracle | 1 Comment »
Changed Data Capture in ODI
Posted by Dylan Wan on June 9, 2008
ODI is the tool will also be used to develop the ETL (or ELT) for Oracle BI Applications. ODI supports Changed Data Capture by its journalizing module.
My understanding of CDC flow in ODI is as follows: Read the rest of this entry »
Posted in BI, BI Application, BI Work, Oracle, Oracle Data Integrator, Sunopsis | Tagged: ODI | Leave a Comment »
