I’ve had difficult time to find “vanilla” list of directories, so storing here as a reference. Informatica PowerCenter 10.0.
Continue ReadingDate in ISO8601 Format in Oracle DB
Below the code example how to get date format as ISO8601. First example is current time zone. Second example is valid if your database is actually in UTC time zone. SELECT to_char(SYSTIMESTAMP, ‘YYYY-MM-DD”T”HH24:MI:SS.FF6TZH:TZM’) AS ISO8601 FROM dual; SELECT to_char(SYSTIMESTAMP, ‘YYYY-MM-DD”T”HH24:MI:SS.FF6″Z”‘) AS ISO8601_UTC_format FROM dual;
Continue ReadingOracle Warehouse Builder nepalaiko ryšio su duomenų baze
OWB 11g nepalaiko ryšio su duomenų baze (angl. keep alive). Palikus ilgesniam laikui, DB suveikia “time out” ir OWB atjungiamas. Labai negerai, jei pamirštama viską išsaugoti. Tenka išnaujo jungti OWB ir pakartoti pakeitimus.
Continue ReadingHow Different RAM Consumption OBIEE11g by Installation Type
As we all know OBIEE 11g has three install types: Simple Install, Enterprise Install, Software Install. We had low end PC with 2GB RAM and RHEL6 and OBIEE Standard Editon One Licence 11.1.1.7.0 64bit linux. So we had to make decision which install type to use to stay minimal. Here are results for OBIEE + […]
Continue ReadingProjektai su Oracle Business Intelligence ir duomenų sandėliais
Ataskaitos, duomenų sandėliai, analitika, grafikai, žemėlapiai, atsakymai, verslo procesai, sprendimų priėmimo pagalba. info@allthingsdata.eu
Continue ReadingKaip importuoti egzistuojančias lenteles į Oracle Warehouse Builder
Į Oracle Warehouse Builder 10g importuoti lenteles tenka, kai lentelės sukuriamos per SQL skriptus, o ne per OWB įrankį. OWB11g versijoje labai panašiai vyksta lentelės importas. Daroma prielaida, kad lentelė jau yra duomenų sandėlio schemoje. Atsidarome Design Center. Ant duomenų sandėlio duomenų bazės modulio spaudžiame dešinį ir Import… Atsidariusiame lange spausti Next> Palikti pažymėta tik […]
Continue ReadingEnvironment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da tabase unique name
emctl status dbconsole command gives error “Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name”. How to fix this error? Add environment variable. Go to Start > Control Panel > System On the left press Advanced System Options Go to Environment Variables… Pres New… Enter Variable name “ORACLE_UNQNAME” and Variable value “orcl”. […]
Continue ReadingHow to Determine Number of Sockets for OBISE1
One of Oracle Business Intelligence Standard Edition One requirements (or limitations) is max 2 socket server. How to determine that? On windows machines I run WinAudit program. In summary page “Number of processors” it shows physical number of CPU, that means physical number of sockets. However, I know that I have two cores 🙂 So, […]
Continue ReadingSome Intelligence About Oracle Open World 11’ Events
Below there is the Europe map, where events will take place. England and Germany are the countries where the biggest number of events is planned. Does it mean, that in these countries have the biggest clients? Or, are they the most geographically convenient? It would be so nice, that at least one event happened in […]
Continue ReadingRules for data warehouse design and implementation
Here are some rules I follow when designing data warehouse. Fact attributes, which will be joined to dimensions can not be null. Instead add some predefined constant.
Continue Reading