I’ve had difficult time to find “vanilla” list of directories, so storing here as a reference. Informatica PowerCenter 10.0.
Informatica PowerCenter 10 default list of directories in infa_shared
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;
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.
OWB time out
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 + Publisher only installation. No EssBase or Real Time Decisions:
Enterprise Install consumes less RAM than Simple Install – by ~200 MB. Would be nice to prove with more tests. That’s a bit controversy as enterprise install has node manager running, extra managed server running. So it’s at least two more services running than Simple Install case.
=0.172+1.5+4.1+1.3+15+9.8+0.684=32.556 MB
=0.004+3.1+0.004+696.7+0.004+408.2=1108.012 MB
Total = 1140 MB
=0.008+1.7+0.852+8+23.4+1.7+6.7=42.36 MB
=0.044+0.044+1300=1300.088 MB
Total = 1343.14 MB
Ataskaitos, duomenų sandėliai, analitika, grafikai, žemėlapiai, atsakymai, verslo procesai, sprendimų priėmimo pagalba.
info@duomenusandelys.lt
Į 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 Tables ir “Use a synonym to lookup objects”. Bus atrinktos tik lentelės. Spausti Next>
Išskleisti šaką “Tables” ir sąraše surasti norimą lentelę. Šiuo atveju TIME_DIMENSION
Permesti pažymėtą lentelę į dešinę pusę ir spausti Finish
Lentelė įkeliama
Įkėlimo būsenos langas. Spaudžiamas OK
Lentelė atsiranda duomenų sandėlio modulio lentelių sąraše.
Dabar ją reikia sukonfigūruoti, kad nebūtų iš naujo diegiama į schemą. Apsisaugome nuo sukurtos lentelės ištrynimo ar perrašymo. Ant lentelės spaudžiame dešinį ir Configure…
Nuimame varnelę ties Deployable. Ši lentelė bus matoma ir galima naudoti OWB projekte, bet ji nebus diegiama iš OWB įrankio, nes ji buvo sukurta per SQL skriptus.
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”. Variable value you can find in Control Panel > Services list. Find service OracleServiceXXX, where suffix XXX is your Oracle service name. This suffix goes as environment variable value.
In New System Variable dialog box press OK. In Environment variables window press OK. In System Properties window press OK. Close System window in Control Panel.
Start command window again and enter command
echo %ORACLE_UNQNAME%
Output line should show
ORCL
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, I think program shows correct information.
Two cores in one socket CPU:
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 Lithuania or in one of Baltic states.
Here are some rules I follow when designing data warehouse.