Recent content by OLAPer

Hi Astra There is a distinction, in my view, from the size of the data warehouse and the model you choose; they are mutually exclusive. I have developed schemas that use a pure Star Schema, that are several hundred gig in size. The business reporting requirements is the key driver in my...

Dear all I have been trying to get a test environment setup so that a few of us at work can learn the basics before our live system, goes live !!! I am having some real problems! During the installation of 4.6C I got the RADDBDIF error. I checked the SAP OSS and found that the program could...

Dear All I am having problems with an Oracle installation that I have recently undertaken. I have done a created two instances of a database on the one Windows 2000 Advanced Server box. The problem I am having is that only one Intelligent Agent/Data Gather will come online at a time. Please...

Hello What I want to do is retrieve the contents of a directory, from which I will import data. The reason I want to do a listing is that the number of files may vary, although all of them will be CSV format. I want to then loop round and import each one. I know that I can use...

Hi people! I am starting a new role where the company has implemented SANDs Nucleus database. I was wondering whether anyone reading this might be able to give me an insight into the workings of Nucleus. Most importantly the database uses Bit-Map Vector Indexing, which I believe is not really...

EdVassie Thanks for your post. The reason for the EXISTS is to ensure that only records that have a relevant record in table2 are updated. The reason for this is that otherwise a NULL is written; the column I am updating is 'NOT NULL' ! :( I will try to obtain some metrics for the queries, I...

Hi everyone ! I have a quick question regarding Index usage. I am wanting to speed up an update, the columns that I am using to link the relevant tables are not indexed. I was wondering how the UPDATE command uses the INDEX created on a column? Any assistance appreciated. OLAPer ::->

Has anyone heard of Media by a Canadian software company called Speedware. I believe they have seperated the BI group and called it Visionyse ? www.visionyze.com and www.speedware.com Let me know what you think if you have used these ! ::-)

"To do Data Warehousing" !? Well, the skills for physically creating the schema is one thing, the skills required to design and develop a schema that meets the business requirements is another. There is also the consideration of whether or not there is a requirement for...

In a correlated sub query is it better to use EXISTS or IN? Is it dependent on whether or not an index exists? Here is an example: UPDATE TABLE1 A SET A.COL1 = (SELECT B.COL2 FROM TABLE2 B WHERE...

There are several areas on the web including: www.olapreport.com www.knowledgecenters.org www.datawarehousing.com/papers.asp www.dwinfocenter.org www.dmreview.com - has some good articles and papers http://businessintelligence.ittoolbox.com http://datawarehouse.ittoolbox.com Also a good...

The problem in the SQL is that there needs to be a WHERE for the UPDATE in order to limit the update to those records that actually exist in the other table. The S_CONTACT table contains more records than the UP_S_CONTACT table so the update needs to know which ones to update, otherwise the...

OK, it really hasn't taken me 4 days to run the script, but there have been some problems. Firstly the script above works, the problem I had was that there were erroneous duplicate records in the EIM_CONTACT table, hence the return of the correlated sub select was more than one row.......so the...

stoyanbd It would be useful if you would share your answer with the rest of us...... It is important to use these types of groups for both asking questions, but also providing help and assistance, so that if someone else has a similar question they don't have to start a new posting ...

I guess my answer is a question really ! Do you not merely try to open the file, if it can't be opened then it must be open !!! ?????? Is this one way of checking ? OLAPer