Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by OLAPer

  1. OLAPer

    Data Model?

    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...
  2. OLAPer

    RADDBDIF WRITE_FAILED error (4.6C/Oracle817)

    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...
  3. OLAPer

    Intelligent Agent....not so !

    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...
  4. OLAPer

    How to list directory contents?

    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...
  5. OLAPer

    Nucleus Database from SAND

    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...
  6. OLAPer

    Performance enhancing of correlated query?

    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...
  7. OLAPer

    Indexes....Update !

    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 ::->
  8. OLAPer

    Is there a good OLAP reporting tool

    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 ! ::-)
  9. OLAPer

    Start doing datawarehousing

    "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...
  10. OLAPer

    Performance enhancing of correlated query?

    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...
  11. OLAPer

    OLAP documentation

    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...
  12. OLAPer

    Why does this SQL not work !?

    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...
  13. OLAPer

    Update of table using joined tables !?

    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...
  14. OLAPer

    strange result

    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 ...
  15. OLAPer

    checking to see if a file is open

    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
See more

Part and Inventory Search

Back
Top