Archive for November, 2011
Implicit Fact Column in OBIEE
Often time you will come across scenario where in presentation catalog you have 2 or more fact tables and couple of dimensions. And not all the fact tables are joined with all the dimensions. And when you just query the data out of dimension which is not joined to a fact table. It will give [...]
OBIEE Administrator Task
I often get questions via Contact US page on as below. And decided to write a small post to address this what are the duties of OBIEE Admin ? I want to know the day to day activities of OBIEE Admin, Can you please send me if is there any material regarding admin tasks of [...]
Oracle Data Warehouse Administration Console (DAC) interview questions
In this post I will discuss some interview questions on Data Warehouse Administration Console (DAC) which checks the key concepts about tool. Check back often as I will be adding the answers here as an when I will get some time over the week ends. If you are looking for some DAC an electronic subject [...]
Informatica integration service issue with DAC
If you are getting below error and/or DAC is not able to test integration services please read on .. ERROR: The command: [pingserver] is deprecated. Please use the command [pingservice] in the future. WARNING: Lost server connection. ERROR: Cannot connect to Integration Service [Integration_Service:4001]. I have see that May times DAC acts so weirdly. DAC [...]
OBIEE interview questions
Below are list of questions you may face during interview. This is part of overall effort to put the interview questions for OBIEE, DAC, Informatica , Oracle Pl\sql and DW Concepts Thing to remember, it also depends on weather interview you are facing is for consulting or full time ? in requirement OBIEE is good [...]
unmatched RepositoryStamp issue in DAC
Sometime dac throws below error when accessing dac from command line. ERROR: com.siebel.etl.net.DACCommandLine main INFO: Illegal message received, with unmatched RepositoryStamp! Ignoring it. Here is what you can do to resolve this error 1- DAC server and client repository stamp are not in same. ( This happens when we move dac repository from different client [...]