Here is the wiki entry I prepared how to schedule manually jobs for mapping execution in Oracle Warehouse Builder 10g (OWB10g).
Continue ReadingOWB patarimai #1
Nenaudoti dimensijos atributo, kuris yra išorinis raktas agregavimo funkcijoje ar duomenų išvedimui. Tokiu atveju geriau sukurti dubliuotą atributą. Iš duomenų šaltinio į OWB įkelti visas lenteles ir visus jų stulpelius (jeigu jų nėra tūkstančiai). Dažniausiai tai apima vienos duomenų bazės ar schemos kontekstą. Mapping’uose naudoti tik tuos atributus, kurių reikia. Dėl greitumo nepermetinėti visų atributų […]
Continue ReadingOracle Warehouse Builder 10g pamokos
Ką tik pasikartojimui įveikiau pradinį OWB 10.2 tutorialą “Setting up the Oracle Warehouse Builder Project with OWB Database 10g Release 2“. Ta dalis su Oracle Workflow Business Intelligence SE1 10g atveju jau instaliuota ir yra schema su OWF_MGR. Naudinga. Eilėje laukia dar keli kiti OWB 10.2 tutorialai Sekantis – supratau kaip reikia elgtis su OWB […]
Continue ReadingShould I Import All Source Database Table Metadata to Oracle Warehouse Builder or One By One
In the beginning of BI project implementation I had this question: Should I import all source database (Oracle schema) table metadata to Oracle Warehouse Builder? Or, just tables needed at this moment of implementation? The answer is YES! You should import all tables from source database (Oracle schema). Why? Because BI system eventually should be […]
Continue ReadingTransform MSSQL Tables to Views for Input to Oracle Warehouse Builder
This code is written by myself. You can use it to generate views from tables in MSSQL database. These generated views are input to Warehouse Builder as a source database objects. The best part of it, that it does a bit of validation and transforms CamelCase notation (which is used in MSSQL database object names) […]
Continue ReadingSchedules or Multiple Configurations licensing from OWB 10R2
It appears, from reading Oracle Warehouse Builder 11gR2: Feature Groups, Licensing and Feature Usage Management, that schedules or multiple configurations requires Oracle Warehouse Builder Enterprise ETL license. If you have OWB Core, then scheduling a OWB mapping has to be done using Enterprise Manger Grid Control, Database Control or any other application that can manage […]
Continue Reading